Azure SQL availability
Azure ensures that data is highly available. Even in case of disaster or hardware failure, data is still available, and it provides multiple capabilities to ensure high-availability.
Azure SQL performs automatic backup of the user's database. These databases are backed up in a manner to minimize the time to recover in case of a disaster. It performs a full weekly backup, hourly differential backups, and backup of transaction logs every five minutes. These backups are then stored in a geo-redundant storage which keeps multiple copies across geographies. In case of a disaster, Azure support can help get these backups and restore them.
Azure SQL also provides geo-replication of databases with up to four readable secondary ...
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