Data recovery is a major consideration for IT Pros in any organization. Check out this practical one-hour course, and see how Azure SQL Database makes it much easier by taking care of a lot of the steps for you. Learn how the service provides full-scale high availability and disaster recovery options that can support a variety of business needs. High availability and disaster recovery are built into the product from the ground up, without all the administrative overhead and complexity. Learn about database backups, which are performed automatically to protect your data. Find out how to verify that backups are taken, see how to configure database replicas, and learn to initiate data recovery after user error or regional outage. This Azure SQL Database Data Recovery course can help you with some concepts required for the Microsoft SQL Server certifications and for parts of Exam 70-473: Designing and Implementing Cloud Data Platform Solutions. From implementation to recovery, this course has the details you need. NOTE: If you need a refresher on database concepts, explore the Database Fundamentals course on MVA. Four video modules.
This overview describes the capabilities that Azure SQL Database provides for business continuity and disaster recovery.
SQL Database automatically creates a database backups and uses Azure read-access geo-redundant storage (RA-GRS) to provide geo-redundancy.
Many applications have regulatory, compliance, or other business purposes that require you to retain the automatic full database backups beyond the 7-35 days provided by SQL Database's automatic backups.
SQL Database provides three options for database recovery using the automated database backups.
You may encounter a situation in which you accidentally modified some data in a SQL database and now you want to recover the single affected table. This article describes how to restore a single table in a database from one of the SQL Database automatic backups.
Azure SQL Database capabilities for recovering from an outage.
An overview of authentication requirements for disaster recovery.
Learn how to use Active Geo-Replication in SQL Database to design database applications resilient to regional failures and catastrophic outages.
This article describes several DR strategies for elastic pools that leverage these SQL Database business continuity features.
Learn how to use Geo-Replication in SQL Database to enable rolling upgrades of your cloud application.
An overview of SQL Database Active Geo-Replication
In this tutorial, you learn how to use the Azure portal to backup and restore databases.
Saving please wait...