Home
Do You Know How to Backup Data on SQL Azure?
  v3.0 Posted at 3/02/2015 1:22 PM by Duncan Hunter

​Built-in Automatic Backup in Azure SQL Database

Microsoft Azure SQL Database has built-in backups to support self-service Point in Time Restore and Geo-Restore for Basic, Standard, and Premium service tiers.

You should use the built in automatic backup in Azure SQL Database versus using T-SQL.

​  ​​​    T-​​​SQL: CREATE DATABASE destination_database_nameAS COPY OF[source_server_name].source_database_name​​​​

Figure: Bad example - Using T-SQL to restore your database​
Azure-restore.jpg
Figure: Good example - Using the built in SQL Azure Database automatic backup system to restore your database

Azure SQL Database automatically creates backups of every active database using the following schedule: Full database backup once a week, differential database backups once a day, and transaction log backups every 5 minutes. The full and differential backups are replicated across regions to ensure availability of the backups in the event of a disaster.

Backup Storage

Backup storage is the storage associated with your automated database backups that are used for Point in Time Restore and Geo-Restore. Azure SQL Database provides up to 200% of your maximum provisioned database storage of backup storage at no additional cost.​

Service TierGeo-RestoreSelf-Service Point in Time RestoreBackup Retention PeriodRestore a Deleted Database

Web

Not supported

Not supported

n/a

n/a

Business

Not supported

Not supported

n/a

n/a

Basic

Supported

Supported

7 days

Standard

Supported

Supported

14 days

Premium

Supported

Supported

35 days

Figure: All the modern SQL Azure Service Tiers support back up. Web and Business tiers are being retired and do not support backup. Check Web and Business Edition Sunset FAQ​ for up to date retention periods.

Learn more:

Other ways to back up Azure SQL Database:


Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: