Do You Know How to Backup Data on SQL Azure?
3/02/2015 1:22 PM by
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
- 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 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 Tier||Geo-Restore||Self-Service Point in Time Restore||Backup Retention Period||Restore a Deleted Database|
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.
Other ways to back up Azure SQL Database:
Do you feel this rule needs an update?