How to backup Azure SQL database

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.

How to backup Azure SQL database

Step-3: Click on the Manage Backups link on your Azure SQL database window.

How to configure backup Azure SQL database

Step-4: Select your database from the list and click on the Configure retention link from the Configure policies section.

Configure backup Azure SQL database

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.

Create backup Azure SQL database

Step-6: Now click on the yes button on the below popup for the confirmation.

Configure backup Azure SQL database

Now you can see the successful message “Retention policies updated successfully for selected databases

Why to Configure backup Azure SQL database

Now you can see the changes are reflecting for your Azure SQL database

How to Configure backup Azure SQL database

You may like following Azure tutorials:

Conclusion

This tutorial, we learned the below things:

  • How to backup Azure SQL database

Leave a Comment