How to backup Azure SQL Database?

+1 vote
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?
Jan 22 in Azure by Karan
• 19,080 points
7,399 views

1 answer to this question.

0 votes

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

answered Jan 22 by Sirajul
• 58,130 points

Related Questions In Azure

+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
884 views
0 votes
1 answer

How can I copy SQL Azure database to a local development server?

There are certain ways to do this: Using SSIS ...READ MORE

answered Jun 26, 2018 in Azure by null_void
• 3,220 points
284 views
0 votes
2 answers

How to restore SQL Server .bak file to Azure SQL Database?

To restore SQL Server .bak file you ...READ MORE

answered May 27, 2019 in Azure by sherry
• 140 points
19,333 views
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 8, 2018 in Azure by club_seesharp
• 3,450 points
2,798 views
0 votes
1 answer

How is Azure Cosmos db different from an Azure SQL db?

Azure Cosmos DB is Microsoft’s globally distributed database ...READ MORE

answered Jan 10 in Azure by Sirajul
• 58,130 points
715 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What is Azure SQL database? How to connect to Azure SQL database?

Azure SQL Database is a general-purpose relational ...READ MORE

answered Jan 13 in Azure by Sirajul
• 58,130 points
308 views
0 votes
1 answer

How to create table in Azure SQL Database?

Creating tables in Azure SQL Database: In Object Explorer, ...READ MORE

answered Jan 22 in Azure by Sirajul
• 58,130 points
4,266 views