In this azure tutorial, we will discuss How to backup Azure SQL database. Apart from this, we will also discuss on few other topics
How to backup Azure SQL database
When we are thinking of the way to take the backup of the Azure SQL database, there are many questions coming into our mind like How do I back up my Azure SQL Database? How can I do It using the Azure Portal? Is there a way to achieve this using the portal? etc
Let’s discuss here, how we can do this using the Azure Portal. Follow the below steps to back up the Azure SQL database.
Step-1: Login to the Azure portal (https://portal.azure.com/)
Step-2: Click on your Azure SQL database you created.
Step-3: Click on the Manage Backups link on your Azure SQL database window.
Step-4: Select your database from the list and click on the Configure retention link from the Configure policies section.
Step-5: Fill the below options based on your business requirement.
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 for How long would you like weekly backups to be kept?
Same way 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.
Step-6: Now click on the yes button on the below popup for the confirmation.
Now you can see the successful message “Retention policies updated successfully for selected databases“
Now you can see the changes are reflecting for your Azure SQL database
You may like following Azure tutorials:
This tutorial, we learned the below things:
- How to backup Azure SQL database