For Disaster recovery scenario , I have created a Primary DB and using standard Geo replication , created a secondary replica.
I wanted to simulate the DR / DR Drill so I have used the below powershell CMDLET for terminating the the continuous copy relationship and to promote the secondary replica to primary.
Stop-AzureSqlDatabaseCopy -ServerName "S1"-DatabaseName "ActiveGeoReplicationDemo"-PartnerServer "S2"
This works fine for Active geo-replication, but throwing error for the Standard geo-replication as below,
Stop-AzureSqlDatabaseCopy : Friendly termination of an offline secondary relationship is not supported.
I thought the deletion of primary db would promote the secondary to primary automatically and deleted the primary. As expected, with active Geo-replication , the secondary has been promoted to the primary But in the Standard GEO-Rep still the seconday is Nonreadable and in the offline status.
So the Question is , How can i promote the non-readable Secondary DB to primary using Standard geo-replication? ( How Fail-over and fail-back to be done?)
It would be great if i get the powershell cmdlets or some references for this.
Aucun commentaire:
Enregistrer un commentaire