Post reply

DB Mirroring and merge replication

  • June 2, 2009 at 5:56 am

    #138186

    Hi

    I've just come back to the 'real world' as a production DBA after several years in the wilderness as a Development DBA. Can anyone help with the following question:

    I've been asked to set up an active/active failover cluster. The client wants an automated failover.

    I've looked into DB mirroring which I've not used for over 10 years (when i was a sybase DBA).

    the real question is this: Can you configure database mirroring with merge replication so that in the event of a priciple node failure connections and further db updates etc... will be passed to the mirror. I know that a witness server is required to do this automatically.. what happens when the principal is online again, my guess is if merge replication can be configured with mirroring then the 2 environments will synchronise when the principal is up again... Any thoughts / comments or pointers to decent articles would be greatly appreciated.

    If there's no merge replication I guess the 2 DB's will be out of sync...

    thanks

    Paul

  • June 2, 2009 at 7:50 am

    #1003418

    After further reading I think mirroring alone will work as the principal and mirror use log sequence numbers to establish synchronisation. Can anyone confirm or deny?

    thanks

    Paul

  • June 2, 2009 at 8:26 am

    #1003431

    You can use Replication and mirroring at the same time, you should use a remote distributor for the replication.

    Microsoft have a guide for setting this up;

    http://msdn.microsoft.com/en-us/library/ms151799.aspx"> http://msdn.microsoft.com/en-us/library/ms151799.aspx

  • June 3, 2009 at 3:01 am

    #1003850

    Thanks Steve!!!

  • June 3, 2009 at 3:13 am

    #1003856

    This might intrest you

    http://msdn.microsoft.com/en-us/library/ms190664(SQL.90).aspx

    Tanx 😀

Viewing 5 posts - 1 through 4 (of 4 total)

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