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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-12 : 08:25:55
|
| spiros writes "How can you set up 2-two transactional replication so that each database server is a publisher and a subscriber, we want to use push subscription on both servers, so that if one server goes down, then it can be sync'ed when it comes back up again.I have successfully setup one-way transactional replication from one database to the other, then when I set transactional replication the other way, replication was still successful from the 1st server --> 2nd server, but then the 2nd server tried to add the record back to the 1st server, which failed. How can I stop the 2nd server from trying to update with 1st server?" |
|
|
|
|
|
two-way transaction replication in SQL Server 2000