Post reply

dbmirroring and replication both in the same databae

  • August 2, 2010 at 12:48 am

    #387478

    Hi all,

    for publisher database if we configure database mirroring,how replication works.

    if fail over happens,how mirror server use the distributor....how we need to configure that.

    as far as my knowledge we need to add both principal and mirror as a publishers for the singe distributor.

    could u help me inn this

    thanks,

    anjali

  • August 2, 2010 at 10:21 am

    #1201118

    Search Books Online for the heading "Replication and Database Mirroring" and read that first. This should give you what you need. Once you have read that check back here with specific questions.

  • August 2, 2010 at 11:35 am

    #1201149

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

    Shared distributor, recommended this is remote from both servers. I suppose that if I had to put it on a server, I'd put it on the mirror server, not the principal.

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

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