sql server - SQL Azure Standard Geo replication - Promote Non readable secondary replica to Primary -
for disaster recovery scenario , have created primary db , secondary replica using standard geo replication.
i wanted simulate dr / dr drill have used below powershell cmdlet terminating the continuous copy relationship , promote secondary replica primary.
stop-azuresqldatabasecopy -servername "s1"-databasename "activegeoreplicationdemo"-partnerserver "s2"
this works fine active geo-replication, throwing error standard geo-replication below,
stop-azuresqldatabasecopy : friendly termination of offline secondary relationship not supported.
i thought deletion of primary db promote secondary primary automatically , deleted primary. expected, active geo-replication , secondary has been promoted primary in standard geo-rep still secondary non readable.
so question , how can promote non-readable secondary db primary using standard geo-replication? ( how fail-over , fail-back done?)
it great if power-shell cmdlets or references this.
this example forcibly terminates continuous copy relationship server hosts secondary database. (this working sample)
$mydbcopy = get-azuresqldatabasecopy -servername "t4xl86670k" -databasename "failover" $mydbcopy | stop-azuresqldatabasecopy -servername "t4xl86670k" -forcedtermination
reference: https://msdn.microsoft.com/en-us/library/dn720223.aspx
Comments
Post a Comment