Aged Yak Warrior
Posted - 12/04/2013 : 22:15:38
| Hi All,
We have set transactional replication.
I was getting this error:
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)
So i did update the status column using below query:
Set [status] = 2
where publisher_db = 'MarkedExpiredDB'
After i did reinitialization , all the rows are replicated but its again and again reinitializing please suggest.
SQL Developer and DBA