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
  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.

Share This Page