I keep getting the following error on Transactional Replication setup in SQL 2005.
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)
Get help: http://help/21074
The subscription expiration option has been set to
"Subscriptions never expire, but they can be deactivated until they are reinitialized."
I know we should not update the system tables but updating distribution..MSSubscriptions status to 2 resolves the issue.
Is there a fix for this problem?
View Complete Post