Log-shipping .. interesting question

  • 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 🙂

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply