Azure SQL Database – Restore DB from Long Term Retention backup

Praveen Kumar Sreeram's Blog

In our previous article listed below, we have learned how to create a Long term retention backup of an Azure SQL Database which lasts for 10 years.

In this article, let see how to restore the backup taken as part of Long term retention backup. Navigate to the SQL Servers for which you have configured the Long Term retention backup as shown below.

1_selectsqlserver

The essentials blade lists all the databases associated with the selected logical SQL Server as shown below.

2_selectdatabase

Click on the required database. In your case, there might be multiple databases. You need to choose the right database that you would like to restore.

3_selectrestore

Now, click on Restore button as shown in the above screen capture.

4_selectbackup

In the above Restore blade, click on the Long-term tab to choose the required settings. Below are the settings that…

View original post 183 more words

Advertisements

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