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, 2020 in Azure by Karan
• 19,610 points
22,925 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

Hope this helps!!

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

Thanks!!

answered Jan 22, 2020 by Sirajul
• 59,230 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
2,420 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
1,008 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 28, 2019 in Azure by sherry
• 140 points
33,079 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 9, 2018 in Azure by club_seesharp
• 3,450 points
6,544 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, 2020 in Azure by Sirajul
• 59,230 points
1,915 views
0 votes
1 answer

What are azure functions? What is their use?

Azure Functions is a serverless computing service hosted ...READ MORE

answered Jan 10, 2020 in Azure by Sirajul
• 59,230 points

edited Jun 27, 2023 by Khan Sarfaraz 1,782 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, 2020 in Azure by Sirajul
• 59,230 points
1,295 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, 2020 in Azure by Sirajul
• 59,230 points
34,662 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP