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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Replication

Author  Topic 

sathireddy
Starting Member

1 Post

Posted - 2010-08-17 : 06:45:18
Hi,
How to synchronize the db's in Transactional replication when replication is failure

please give me reply
regards,
sathireddy

sathireddy

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-17 : 14:05:19
depending on the nature of the failure, you may need to re-run the snapshot agent and re-synch. you can do this in the replication monitor by right-clicking the publication and choosing "reinitialze all subscriptions"

why did it fail? and what failed? distribution agent? log reader agent? what errors are you getting?

have you taken corrective action to prevent future occurrences?
Go to Top of Page
   

- Advertisement -