This Azure tutorial will discuss various approaches to backup Azure SQL database.
How to backup Azure SQL database
Follow the below steps for Azure SQL backup using the Azure portal.
1. Log in to the Azure portal (https://portal.azure.com/)
2. Click on the Azure SQL database you created.
3. Click the Manage Backups link on your Azure SQL database window.
4. Select your database from the list and click on the Configure retention link from the Configure policies section.
5. Fill in the options below based on your business requirements.
Point in Time Restore Configuration: Select the number of days based on your business needs from 7,14,21,28,35 days.
Long-term Retention Configurations: You can check the Weekly LTR Backups option and select the appropriate choice. How long would you like weekly backups to be kept?
You can choose the appropriate options for Monthly LTR Backups and Yearly LTR Backups based on your business needs.
Then click on the Apply button to save the changes you made.
6. Now click on the yes button on the below popup for confirmation.
Now you can see the successful message “Retention policies updated successfully for selected databases.”
Now you can see the changes are reflected in your Azure SQL database
Backup Azure SQL Database To Blob Storage
We can back up our Azure SQL Database to the Azure Blob Storage using the steps below. Before that, we need to know the prerequisites to work with this requirement.
Prerequisites
- You must have an Azure Subscription or Azure Free Account. If you don’t have an Azure account, Create an Azure free account now.
- You need to have an Azure Storage Account. If you don’t have an Azure Storage Account, create one Azure storage account now.
- You need to install the SQL Server Management Studio.
Create a storage account
The first step is to create a storage account. Follow the below steps to create a storage account.
- Log in to the Azure Portal(https://portal.azure.com/).
- Once you log in to the Azure Portal, search for the Storage Account and click on the search result storage accounts as highlighted below.