Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-07-10 : 18:19:15
|
| Hi all,I'm looking to replicate data to another site with a remote distributor. I also want to mirror the publisher just in case it fails.I'm looking at this article from microsoft - http://msdn.microsoft.com/en-us/library/ms151799.aspxHow should I set this up?Do I first create the replication topology including setting up the subscription, and then do I set up mirroring on the publisher?Regarding section 3 of the article - can you configure distribution for the mirror using management studio or do you have to use stored procedures. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-07-12 : 13:56:59
|
| no you configure mirrorong first then add replication later.configuring distributor at mirror is same as that at subscriber. - http://msdn.microsoft.com/en-us/library/ms151192.aspxDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Mirroring a replication setup