samedi 25 avril 2015

SQL Azure Standard Geo replication - Promote Non readable secondary replica to Primary

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