You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview.md
+4-2Lines changed: 4 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -103,7 +103,7 @@ Use auto-failover groups if your application meets any of these criteria:
103
103
104
104
You may choose to use a combination of database backups and active geo-replication depending upon your application requirements. For a discussion of design considerations for stand-alone databases and for elastic pools using these business continuity features, see [Design an application for cloud disaster recovery](designing-cloud-solutions-for-disaster-recovery.md) and [Elastic pool disaster recovery strategies](disaster-recovery-strategies-for-applications-with-elastic-pool.md).
105
105
106
-
The following sections provide an overview of the steps to recover using either database backups or active geo-replication. For detailed steps including planning requirements, post recovery steps, and information about how to simulate an outage to perform a disaster recovery drill, see [Recover a database in SQL Database from an outage](disaster-recovery-guidance.md).
106
+
The following sections provide an overview of the steps to recover using either database backups or active geo-replication. For detailed steps including planning requirements, post recovery steps, and information about how to simulate an outage to perform a disaster recovery drill, see [Azure SQL Database disaster recovery guidance](disaster-recovery-guidance.md).
107
107
108
108
### Prepare for an outage
109
109
@@ -124,7 +124,7 @@ If you are using active geo-replication or auto-failover groups as your recovery
124
124
125
125
### Perform a geo-restore
126
126
127
-
If you are using the automated backups with geo-redundant storage (enabled by default), you can recover the database using [geo-restore](disaster-recovery-guidance.md#recover-using-geo-restore). Recovery usually takes place within 12 hours - with data loss of up to one hour determined by when the last log backup was taken and replicated. Until the recovery completes, the database is unable to record any transactions or respond to any queries. Note, geo-restore only restores the database to the last available point in time.
127
+
If you are using the automated backups with geo-redundant storage (enabled by default), you can recover the database using [geo-restore](recovery-using-backups.md#geo-restore). Recovery usually takes place within 12 hours - with data loss of up to one hour determined by when the last log backup was taken and replicated. Until the recovery completes, the database is unable to record any transactions or respond to any queries. Note, geo-restore only restores the database to the last available point in time.
128
128
129
129
> [!NOTE]
130
130
> If the datacenter comes back online before you switch your application over to the recovered database, you can cancel the recovery.
@@ -149,3 +149,5 @@ Sometimes an application must be taken offline because of planned maintenance su
149
149
## Next steps
150
150
151
151
For a discussion of application design considerations for single databases and for elastic pools, see [Design an application for cloud disaster recovery](designing-cloud-solutions-for-disaster-recovery.md) and [Elastic pool disaster recovery strategies](disaster-recovery-strategies-for-applications-with-elastic-pool.md).
152
+
153
+
Review the [Azure SQL Database disaster recovery guidance](disaster-recovery-guidance.md) and [Azure SQL Database high availability and disaster recovery checklist](high-availability-disaster-recovery-checklist.md).
Copy file name to clipboardExpand all lines: azure-sql/database/designing-cloud-solutions-for-disaster-recovery.md
+2-3Lines changed: 2 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -52,13 +52,12 @@ After an outage in the primary region, SQL Database detects that the primary dat
52
52
If an outage happens in region B, the replication process between the primary and the secondary database gets suspended but the link between the two remains intact (1). Traffic Manager detects that connectivity to Region B is broken and marks the endpoint web app 2 as Degraded (2). The application's performance is not impacted in this case, but the database becomes exposed and therefore at higher risk of data loss in case region A fails in succession.
53
53
54
54
> [!NOTE]
55
-
> For disaster recovery, we recommend the configuration with application deployment limited to two regions. This is because most of the Azure geographies have only two regions. This configuration does not protect your application from a simultaneous catastrophic failure of both regions. In an unlikely event of such a failure, you can recover your databases in a third region using [geo-restore operation](disaster-recovery-guidance.md#recover-using-geo-restore).
56
-
>
55
+
> For disaster recovery, we recommend the configuration with application deployment limited to two regions. This is because most of the Azure geographies have only two regions. This configuration does not protect your application from a simultaneous catastrophic failure of both regions. In an unlikely event of such a failure, you can recover your databases in a third region using [geo-restore operation](recovery-using-backups.md#geo-restore). For more information, see [Azure SQL Database disaster recovery guidance](disaster-recovery-guidance.md).
57
56
58
57
Once the outage is mitigated, the secondary database automatically resynchronizes with the primary. During synchronization, performance of the primary can be impacted. The specific impact depends on the amount of data the new primary acquired since the failover.
59
58
60
59
> [!NOTE]
61
-
> After the outage is mitigated, Traffic Manager will start routing the connections to the application in Region A as a higher priority end-point. If you intend to keep the primary in Region B for a while, you should change the priority table in the Trafic Manager profile accordingly.
60
+
> After the outage is mitigated, Traffic Manager will start routing the connections to the application in Region A as a higher priority end-point. If you intend to keep the primary in Region B for a while, you should change the priority table in the Traffic Manager profile accordingly.
62
61
>
63
62
64
63
The following diagram illustrates an outage in the secondary region:
Copy file name to clipboardExpand all lines: azure-sql/database/disaster-recovery-drills.md
+3-2Lines changed: 3 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -32,8 +32,8 @@ To simulate the outage, you can rename the source database. This name change cau
32
32
33
33
### Recovery
34
34
35
-
* Perform the geo-restore of the database into a different server as described [here](disaster-recovery-guidance.md).
36
-
* Change the application configuration to connect to the recovered database and follow the [Configure a database after recovery](disaster-recovery-guidance.md) guide to complete the recovery.
35
+
* Perform the geo-restore of the database into a different server as described in [Azure SQL Database disaster recovery guidance](disaster-recovery-guidance.md).
36
+
* Change the application configuration to connect to the recovered database and follow the [Configure a database after recovery](disaster-recovery-guidance.md#configure-your-database-after-recovery) guide to complete the recovery.
37
37
38
38
### Validation
39
39
@@ -63,3 +63,4 @@ Complete the drill by verifying the application integrity post recovery (includi
63
63
* To learn about Azure SQL Database automated backups, see [SQL Database automated backups](automated-backups-overview.md)
64
64
* To learn about using automated backups for recovery, see [restore a database from the service-initiated backups](recovery-using-backups.md).
65
65
* To learn about faster recovery options, see [Active geo-replication](active-geo-replication-overview.md) and [Auto-failover groups](auto-failover-group-sql-db.md).
66
+
* Review [Azure SQL Database disaster recovery guidance](disaster-recovery-guidance.md) and the [Azure SQL Database high availability and disaster recovery checklist](high-availability-disaster-recovery-checklist.md).
0 commit comments