Home > Windows & SQL Server AZURE > Working with Windows Azure Storage –RESTORE DATBASE FROM BACKUP FILE IN BLOB STORAGE- SQL Server 2014

Working with Windows Azure Storage –RESTORE DATBASE FROM BACKUP FILE IN BLOB STORAGE- SQL Server 2014

 

Restoring the Database backup from the Azure Storage blog is pretty simple.

 

Create the credentials

 

 

image

Background Process

 

image

 

RestoreDatabase: Database AdventureWorks2012_BlobRestore

Opening backup set

VDI: "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\BackupToUrl.exe" "r" "p" "680074007400700073003A002F002F0064006200700072006F00780061007A00750072006500730074006F0072006100670065002E0062006C006F0062002E0063006F00720065002E00770069006E0064006F00770073002E006E00650074002F0063006F006E007400610069006E0065007200730074006F0072006100670065002F0041006400760065006E00740075007200650057006F0072006B007300320030003100320031005F00460055004C004C002E00620061006B00" "64006200700072006F00780061007A00750072006500730074006F007200610067006500" "01000000D08C9DDF0115D1118C7A00C04FC297EB010000008A1F704D82DFC340B81470F9C845106F000000001200000061007A007500720065006B00650079000000106600000001000020000000DA1203D7C8747E05D39E6EB11D2F604D64996C8967133EFA7FC6D34BDF075500000000000E8000000002000020000000A00306C9A38E13BDB7AEA12A3C24C0CF1B6F454E27E127C535ED723B865A685150000000E800B249F7C14428C0D69AEFD21441F08F1EBFEA1F97C7F5E2F446A3AF811974341AC77546D0968A12CBA267207E19F40FBEEF031372D56AEA7FBC143B3410900D9907FAD3F60FEC66A18F485AD5EB2F40000000E4FC1F2D05DB21D31CA753E8777D49D4F8F4032CD277BB71091B34D60582470E0565EE6397F2D4BAAE4C9297F257FC1B8CD9244F4775658BDE6CD1F39E5D6A9D" "NOFORMAT" "4D005300530051004C00530045005200560045005200" "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log" "DB" "41006400760065006E00740075007200650057006F0072006B00730032003000310032005F0042006C006F00620052006500730074006F0072006500" "NOTRACE"

Restore: Configuration section loaded

Restore: Backup set is open

Restore: Planning begins

Restore: Planning complete

Restore: BeginRestore (offline) on AdventureWorks2012_BlobRestore

Restore: Attached database AdventureWorks2012_BlobRestore as DBID=9

Restore: PreparingContainers

Restore: Containers are ready

Restore: Restoring backup set

Restore: Transferring data to AdventureWorks2012_BlobRestore

5 percent processed.
10 percent processed.
15 percent processed.
20 percent processed.
25 percent processed.
30 percent processed.
35 percent processed.
40 percent processed.
45 percent processed.
50 percent processed.
55 percent processed.
60 percent processed.
65 percent processed.
70 percent processed.
75 percent processed.
80 percent processed.
85 percent processed.
90 percent processed.
95 percent processed.
100 percent processed.
FileHandleCache: 0 files opened. CacheSize: 14

Restore: Data transfer complete on AdventureWorks2012_BlobRestore

Processed 24384 pages for database ‘AdventureWorks2012_BlobRestore’, file ‘AdventureWorks2012_Data’ on file 1.
Processed 3 pages for database ‘AdventureWorks2012_BlobRestore’, file ‘AdventureWorks2012_Log’ on file 1.
Restore: Backup set restored

Restore-Redo begins on database AdventureWorks2012_BlobRestore

Restore VLF headers for 5 headers on database AdventureWorks2012_BlobRestore

Restore VLF headers completed on database AdventureWorks2012_BlobRestore

RunOfflineRedo logIter.Init(): FirstLsn(PruId: 0): 0x54:0x38:0x4a

RunOfflineRedo logIter.Init(): LastLsn(PruId: 0): 0x54:0x68:0x1

OfflineRollforward: StopLsn/LastLsn(PruId: 0): 0x54:0x68:0x1

Rollforward complete on database AdventureWorks2012_BlobRestore

Restore: Done with fixups

Restore: Transitioning database to ONLINE

Restore: Restarting database for ONLINE

Restore: Database is restarted

Resuming any halted fulltext crawls

Restore: Writing history records

Writing backup history records

Restore: Done with MSDB maintenance

RESTORE DATABASE successfully processed 24387 pages in 87.274 seconds (2.183 MB/sec).
RestoreDatabase: Finished

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: