MS SQL server 2005 replication

Posted by hubertus on Server Fault See other posts from Server Fault or by hubertus
Published on 2010-03-17T19:33:34Z Indexed on 2010/03/17 19:41 UTC
Read the original article Hit count: 130

Filed under:
|
|

Hi. I have a problem with replication between 3 servers. I made something like this: server A replicate (transactional replication) to server B (to 'mydb' database), then server B replicate 'mydb' (using transactional replication) to server C. On the beginning it looks and works fine, but something wrong is going on (about 2-3 month later) and replication break up. SQL say that hi can replicate db because db is allready use to replicate. Any one had similar broblem? Mayby someone knows hot can I make alternative configuration to have similar funcionality?

© Server Fault or respective owner

Related posts about sql-server

Related posts about mssql