Azure SQL Database backup
A very important task for any database administrator is backup. This option is automatically enabled in Azure SQL Database. When a new database is created, geo-redundant storage is created in the process and backups are performed in this storage. This feature is provided automatically and free of charge. For Azure SQL Database, SQL Server backup technology is used to create full, differential, and transaction backups. Transaction backups are performed every 12 hours and differential backups every 5–10 minutes, depending on database size and activity. This allows us to have a point-in-time restore by restoring the last full backup before the point selected, all differential backups between the full backup and the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access