Steps on configuring Peer to Peer Replication between two SQL 2005 - 01-30-2006 , 12:24 PM
I need to configure Peer-to-Peer Replication for a database between two SQL
2005 hosts. However I have few newbie questions on doing so:
1. Is it required to have both the SQL servers part of a domain or can this
be achieved with them being in Workgroup mode?
2. I came across this article "How to: Configure Peer-to-Peer Transactional
Replication (SQL Server Management Studio) " at
http://msdn2.microsoft.com/ms152536.aspx. But at many places this article is
very generic. Is there any documentation/articles available which will take a
sample scenario and explain how to configure P2P in SQL 2005.
Re: Steps on configuring Peer to Peer Replication between two SQL 2005 - 01-30-2006 , 12:30 PM
Not exactly a How-to guide, but you can use my setup script if you want to
get things going: http://www.replicationanswers.com/Script3.asp
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
Re: Steps on configuring Peer to Peer Replication between two SQL 2005 - 01-30-2006 , 11:04 PM
1. No, there are no domain requirements for replication.
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Mehul" <Mehul (AT) discussions (DOT) microsoft.com> wrote