Home Forums SQL Server 7,2000 Replication The subscription(s) have been marked inactive..... RE: The subscription(s) have been marked inactive.....

  • I dont have a server with replication enabled with me at the moment, but there is a job that checks for expired pubs by looking at the date of the oldest open (undistributed) transaction and marks sub as expired if past x date. Try disabling the job. Though I suspect that may be bandaiding a bigger problem, probably worth digging more.