Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2005 Mirroring a Publisher in Replication

Status
Not open for further replies.

Soiboy

Programmer
Jul 22, 2002
16
US
I have a Publisher database which is also a Distributor.
I want to initiate a mirroring session with this box as the Principle and with the mirror on a separate box.

In the case of a failure of the Publisher/Distributor box, the mirror will take over of new Principle of the mirroring session, but will it take over the Publisher/Distributor role as well?

Can I continue to have the Distributor be on the Publisher box or must I separate them?

thanks,

Ed
 
Wow, that's a good question. I don't think anyone has actually tried this out yet.

Do you have a test environment which you could establish this and deliberate take down the principal?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top