Replication - Subscription inactive, why ?

[homebrew]

I have a snapshot & a transcation publication on Server A, and a pull subscription for each on Server B.

The distribution agent on ServerA has the error:

"The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated."

Any idea what caused this ..... Everything was fine for a week or so.

Does anyone know of any good books or publications on Replication ? I've got some DBA books that cover the basics, but I'd like something that helps explain the oddball situations.

SQL 2K

[MAK]

http://dbforums.com/t587787.html


For learning replication

http://www.mssqlserver.com/replication/

Books On line.

Microsoft white papers.

[Stephen]

I have had this happen when the distribution task for a subscriber failed due to an extended network outage. Replication will mark the subscription as requiring re-initialisation because the subscriber has not syncronised "recently" (it is configurable).

It would be worth enabling some of the replication alerts so that you get prompt notification of the problem.