Restore from Amazon S3 with LiteSpeed

Today I am going to talk about …hold on… where is my database? WHERE IS MY DATABASE?  

 

It was there 5 minutes ago!! Where did it go? I spent a lot of time setting up the database for this blog. Ok! Do not panic! Do I have a backup?  Oh yes! I just run a backup to Amazon S3 in my previous blog so ...relax...and let’s restore it.

First let’s open the Restore Wizard:

 Then select the type of restore you want to perform

In this case I select the original name of the database and the same server but I could restore the database to a new server and /or with a new name if I wished

 

Yes, please! Continue! I want it and I want it now!

 In the next step let’s choose the backup file to restore. Here it is where our backup and recovery strategy is crucial. Do we have a backup? Is this backup valid? Does it include the data I need now? etc (always practice and test your backup and recovery strategy...you do not want to find out it is not the appropriate one when being in a real disaster scenario).
In this case I am covered as I just run a backup of that database in Amazon S3 and it contains my last changes.

Let's go then! Select Device as Cloud:

 Select the backup file:

 And then select the options you prefer:

 

 

 

 

We can Run the restore immediately, in background or even schedule it. Since I need the database live and kicking as soon as possible and I am not going to do anything else in the meantime, I will select “Run immediately”

 

 

As always we can preview the script LiteSpeed will run by clicking “Preview Script” on the hyperlink

 

In this case the script is:

exec master.dbo.xp_restore_database @database = N'2AdventureWorks2012Dev' ,
@filename = N'2AdventureWorks2012Dev_201705171052.bak',
@filenumber = 1,
@CloudVendor = N'AmazonS3',
@CloudBucketName = N'litespeedbackupstest',
@CloudAccessKeyEnc = N'XXXXXXYYYYYYYYSSSSSSS',
@CloudSecretKeyEnc = N'XXXXXXXXXXYYYYYYYYSSSSSSSSSS',
@UseSSL = 1,
@with = N'STATS = 10',
@with = N'MOVE N''AdventureWorks2012_Data'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\2AdventureWorks2012Dev.mdf''',
@with = N'MOVE N''AdventureWorks2012_Log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\2AdventureWorks2012Dev_1.ldf''',
@affinity = 0,
@logging = 0

GO

 
And below we have the message we always want to read when restoring:  "Successfully restored"

 And here I have my database again! LiteSpeed saved me one more time!

 

And this is all for today.
Hope this helps!

Anonymous