Post a Comment On: Blogpad

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 distributiongo
update MSSubscriptions set [status] = 2
To review pending commands to replicate. At plusblisher:
use distributiongo
exec sp_browsereplcmds
[Image]

source: http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/bcebbe25-d9ea-4d92-9ade-04e7cf9d12d1