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

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -