Wednesday, October 6, 2010

The subscription(s) have been marked inactive and must be reinitialized

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074)

At publisher:

use distribution
go

update MSSubscriptions set [status] = 2

To review pending commands to replicate. At plusblisher:

use distribution
go

exec sp_browsereplcmds

No comments: