February 22, 2012 at 10:51 am
Hi,
Can any one shed best routes for this:
We have servers in different regoins of the world. LD, NY ,,etc.
All the databases on each region are logshipped to its counter region and vice versa.
e.g. LD (mix of primary and secondary) is log shipped to NY (mix of primary and secondary) and vice versa.
If I want to failover LD to NY or NY to LD what is the best way to do it ?
We are just testing the failovers during maintenance window. The primary will remain primary and secondary will remain secondary.
I know that failing over and failing back will be a nightmare for us, but if anyone has done this in a better way would help me out.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
February 22, 2012 at 10:52 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1256152-1550-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply