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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2007-10-09 : 09:09:29
|
| Hello All,We use transactional replication at work. The replication structure is liek thisServer1 replicates to Server2 and Server2 replicates to Server3So the Server2 is subscriber of Server1 and publisher of Server3.The replication was down for almost a day. The log reader agent and distribution agents were down. They had the red cross mark infront of them. The reason was network issues. In that situation is it possible to get the data unsynchronized for that time frame. I am not an expert in the replication. Whenever the distibution agent is down and I make it up and running it catches the transactions from publisher/distributor and updates at the subscriber. But is it possible when the log reader agent is down as well the data may go out of sync.Can anyone tell me:what is Log reader agent, queue reader agent and distribution agent, snapshot agent and their functions in replication?Thanks in advace,-P |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-09 : 23:08:14
|
| If log reader agent stopped for long time, you may need reinitial the replication. |
 |
|
|
|
|
|
Replication concepts