SQL Server Performance

Replication with database mirroring

Discussion in 'SQL Server 2005 Replication' started by WingSzeto, Nov 3, 2006.

  1. WingSzeto Member

    I am testing database mirroring along with replication.

    Server A (primary) and Server B (mirror) are the pair for the mirroring. Server A (publisher) and server C (subscriber) are the pair for the replication. Since Server A and B are doing the db mirroring. I need to configure server B to be the publisher in case server A fails. I follow the BOL 'Replication and Database Mirroring' and got stuck witht the command, sp_adddistributor. Does anyone have any experience following this instruction? It seems I am missing some preparation on the mirror server to make it ready to connect to the distributor. If there are better documentation out there, please advice.

    Wingman
    WingSzeto, Nov 3, 2006
    #2

  2. satya Moderator

    On that section have you referred to other sections such as Database mirroring & replication, I havent' seen any such article on web and if any I will post here.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Nov 24, 2006
    #2

Share This Page