In this lesson, Sharon demonstrates how to restore a the Azure SQL Database workload that was protected using the Azure Backup Server in the previous chapter.
- [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. I've already downloaded it again.
It's available to me. I'm going to go ahead and click Open. I'm going to select the correct server, because I have more than one server registered with the Azure recovery services vault. Next, I'm going to need that passphrase. Remember, I stressed very strongly that you need to put that somewhere where you have access to it. This is why. As I recall, I saved mine on the desktop. Let's go fetch it from there. I'm going to go ahead and open it, and copy my passphrase.
Our external server will now be added. Again, when I say external server, I'm referring to the Azure recovery services vault. After a few minutes, you should see your external DPM online data store, or the Azure recovery services vault be presented to you. I'm going to go ahead and close our window, and there we are. Now I can go ahead and select that database.
Perfect, I'm now able to access that data. I can simply click on Recover, and our recovery wizard will pop up for us. The first step in the recovery wizard is to review our selection. I'm going to go ahead and click Next. In our example here, the only thing I can do is copy that database to a network folder, and that's because of the way I have my environment set up. You may have other options, including recovering to an original instance of SQL, recovering to any instances of SQL, or copying to tape.
I'm going to go ahead and click Next. Now I can go ahead and select my destination. I'm going to go ahead and select from users to public, just for our demonstration. You would pick the folder that best meets your needs. I'm going to go ahead, click OK. Go ahead, click Next. Now you have two options for security. You can either apply the security settings of the destination computer to that recovered file or you can apply the security settings to the recovery point version.
The choice is yours. You'll also notice here that if I was able to recover to a SAN, could click that, or if I was able to send an email notification, I would also have that option. Again, because I'm using a test environment, these options are not available to me. You can go ahead and click Next. You can review your choices, and then recover, and that's it. This could take some time, depending on how much data you are recovering. As this is an empty database, this should not take long at all. And there we go.
In our example, that data has now been transferred. Your final step is to clear the external DPM server. Basically what we're doing when we select this option is removing the connection to the Azure recovery services vault. Therefore, if you'd like to restore from Azure again, you'll have to run through the same procedure of adding the external DPM or the Azure recovery services vault procedure. That's all there is to recovering a SQL database from Azure, when you've used the Microsoft Azure backup server.
- Creating a Recovery Services vault for Azure Backup
- Protecting virtual machines, files and folders, databases, workloads, and file shares
- Restoring virtual machines, files and folders, databases, workloads, and file shares
- Azure Site Recovery scenarios
- Running failover and failback tests
- Replicating an Azure virtual machine