During this video, Sharon demonstrates how to restore the long-term Azure SQL Database backup that we protected in the previous chapter.
- [Instructor] It's been a week since I configured the SQL database long-term backup. And we can now restore data because there's data in the vault. But before we do so, you may notice that the portal looks a little different. And you've heard me say this once, you've heard me say it several times. Azure is a moving target. And we saw this in the last chapter too. Microsoft is always enhancing the Azure portal and including new services and functionality. In this case, we can see that the portal itself has some updates.
For example, the search option at the top is a little more clearly defined, we now have an option for all services, and we have what looks to be a divider for favorites and all of my favorites are listed below. We may see some more changes as we go through this demo. Now, let's go ahead and restore our long-term backup. As you may recall, when we configured this, we had to configure the long-term backup from within SQL server.
We selected long-term backup and we configured the backup. To restore that backup, we actually do it from the SQL database. And we called it CompanyDB. I'm going to go ahead and open that. And right from the overview page, you'll notice that we had the option to restore. And we have two restore options here. We have our point-in-time restore and our long-term restore. The point-in-time restore is for the automatic backups that are included in your plan.
The SQL database that I created was under the basic plan. Therefore, I only have seven days of point-in-time restores. If I created it under the standard or premium tiers, I would have 35 days. If you were going to do a point-in-time restore, you could go ahead, select point-in-time, select your restore point, the time. Your target server is already selected for you. If you had an elastic database pool created, you could go ahead and select it. And you can also change that pricing tier. And at that point, you would go ahead and restore.
We're going to focus on the long-term restore. Here we can go ahead and select the backup. You'll notice that the vault is already pre-selected for us. We don't have to go find the vault. And we can go ahead and select the backup that we'd like to restore. Click select. Just as with the point-in-time restore, we cannot select the target server; that is already chosen for us. And if we had an elastic database pool configured, we could go ahead and select that. I do not. I'm going to leave it as is. We could also go ahead, change the pricing tier, and the subscription is already selected for us.
Before I go ahead and click OK, you'll notice here that I can actually change the database name. I'm going to leave it as is. But you could go ahead and change that as necessary. Go ahead and click OK. Now, the restore could only take a few minutes or may be longer depending on the size of that database. It took a few minutes for my backup to be restored. And to view that, I'm going to go ahead and just pop back in to the resource group itself. You may have to refresh the page, as I do.
And you'll notice that that database has now been restored for us. And we can manipulate that database as required. And that's all there is to it to restoring your Azure SQL long-term databases.
- 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