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-03-03 : 07:31:13
|
| Chris writes "We are running two SQL servers. we will call them SQL1 and SQL2.SQL1 is considered the productions server and SQL2 is the reporting server.We run transactional replication between the two server and have SQL1 as the publisher/distributer and SQL2 as the subscriber.about once a week we experience an issue with transactional replication were it just stops working. It is as if SQL02 (the subscriber) will not take ODBC connections.All we can do to fix it is stop and start the SQL database on SQL02 and then we tell SQL01 to start replicating again. It will work for a week or so then stop again.What can we do to help track the problem?We are running SQL07SQL1 has SP1 and SQL2 has SP2Thanks,Chris." |
|
|
|
|
|
SQL07 - Replication Issue