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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Replication failed

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2008-04-01 : 08:54:19

we had a failure on our Publishing SQL Server (2000)

now the distribution agents are marked inactive and must be re-initialized. How do I do this?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-01 : 11:18:09
Did you move servers? Check jobs history or error logs. Restart distribution agent and reapply snapshot agent.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-01 : 23:24:10
You can do it re-initialize replication in subscriber properties, then start snapshot agent.
Go to Top of Page
   

- Advertisement -