How to backup Azure SQL Database

Question

How do I back up my Azure SQL Database such that the data is retained for a long term. I don't want to do this using any API. How can I do It using the Azure Portal? Is there a way to do this using the portal?

Answer 1

In Azure SQL Database, you can configure a single or a pooled database with a long-term backup retention policy (LTR) to automatically retain the database backups in separate Azure Blob storage containers for up to 10 years. You can then recover a database using these backups using the Azure portal or PowerShell.

Configure long-term retention policies :

You can configure SQL Database to retain automated backups for a period longer than the retention period for your service tier.

1. In the Azure portal, select your SQL server and then click Manage Backups. On the Configure policies tab, select the checkbox for the database on which you want to set or modify long-term backup retention policies. If the checkbox next to the database is not selected, the changes for the policy will not apply to that database.
   
   

2. In the Configure policies pane, select if you want to retain weekly, monthly or yearly backups and specify the retention period for each.
   
   

3. When complete, click Apply.

To view backups and restore from a backup refer to https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure

Hope this helps!!

To know more about Azure, enroll today with our Azure certification course.

Thanks!!