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 FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBinnBackupToUrl.exe" "r" "p" "680074007400700073003A002F002F0064006200700072006F00780061007A00750072006500730074006F0072006100670065002E0062006C006F0062002E0063006F00720065002E00770069006E0064006F00770073002E006E00650074002F0063006F006E007400610069006E0065007200730074006F0072006100670065002F0041006400760065006E00740075007200650057006F0072006B007300320030003100320031005F00460055004C004C002E00620061006B00" "64006200700072006F00780061007A00750072006500730074006F007200610067006500" "01000000D08C9DDF0115D1118C7A00C04FC297EB010000008A1F704D82DFC340B81470F9C845106F000000001200000061007A007500720065006B00650079000000106600000001000020000000DA1203D7C8747E05D39E6EB11D2F604D64996C8967133EFA7FC6D34BDF075500000000000E8000000002000020000000A00306C9A38E13BDB7AEA12A3C24C0CF1B6F454E27E127C535ED723B865A685150000000E800B249F7C14428C0D69AEFD21441F08F1EBFEA1F97C7F5E2F446A3AF811974341AC77546D0968A12CBA267207E19F40FBEEF031372D56AEA7FBC143B3410900D9907FAD3F60FEC66A18F485AD5EB2F40000000E4FC1F2D05DB21D31CA753E8777D49D4F8F4032CD277BB71091B34D60582470E0565EE6397F2D4BAAE4C9297F257FC1B8CD9244F4775658BDE6CD1F39E5D6A9D" "NOFORMAT" "4D005300530051004C00530045005200560045005200" "C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLLog" "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

Leave a Reply

Your email address will not be published. Required fields are marked *