Replication with database mirroring | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication with database mirroring

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