| Table of Contents | ||||
|---|---|---|---|---|
|
1. Introduction
In this section, we will discuss how to create a DR database using standby Multiplatform. There are certain pre-requisites when creating a DR database for SQL Server.
...
6. Second Configuration is created for the database Adventureworks. Now click on Set up now to create a Second Standby Database on Host tahi
...
8. Standby Database Adventureworks created on host Tahi.
...
Performing Graceful switchover
Performing Switchover between configuration 1, swaps the role Database AdventureWorks on tahi to Primary and toru to Restoring. The change is reflected on the 2nd configuration where it’s Status is Restoring in toru and wha. Even though synchronisation doesn't happen between toru and wha , it is recommended to Disable Automatic Standby update and Observer.
...
After switchback of configuration (1), Enable the Auto Standby update and Observer for Configuration (2)for toru and wha
...