Note: Name of the failover group must be globally unique. (.database.windows.net)
Adding a single database to failover groups
b) Create a new SQL Database named "failover-group-db1" and a SQL Server named "failover-group-server1" in 'Australia East" region.
c) Navigate to the "failover-group-db1" and click on Failover Groups and create a failover group name as "fog-failover-group"
d) Create a secondary server named "failover-group-db-server2" in "Southeast Asia" region and add "failover-group-db1" database to the failover group.
a) Navigate to the "fog-failover-group" under "fileover-group-server-1" and notice that the "failover-group-db-server1" has the primary role and "failover-group-db-server2" has the secondary role.
b) Initiate the failover by clicking the "Failover" button and once the failover is complete, "failover-group-db-server2" has the primary role and "failover-group-db-server1" has the primary role.
No comments:
Post a Comment