From the course: Microsoft Azure: Backup and Disaster Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Restore an Azure SQL Database

Restore an Azure SQL Database - Azure Tutorial

From the course: Microsoft Azure: Backup and Disaster Recovery

Start my 1-month free trial

Restore an Azure SQL Database

“

- [Instructor] Let's go ahead and restore a SQL database using the Azure backup server. The first thing we need to do is ensure that we are in recovery. Down at the bottom, just click on Recovery. From our local DPM data, or the local store, we can go ahead and expand out. In this example, I'm just going to go ahead and grab the master database. Next, I can go ahead and select the date that I'd like to restore from, and then the time. You'll notice here that I have three options, one for first thing in the morning, then I have two evening backups, one from disk, and one from online. At this point I can't recover from online because I have not configured the Azure backup server to retrieve data from the recovery services vault in Azure. To do so, click on Add External DPM, and you'll need the vault credential. You would have downloaded this, when when you created the Azure backup service, but those credentials are only good for two days. Therefore, you may have to download it again…

Contents