Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-12-04 : 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:
USE distribution
Update [MSsubscriptions]
Set [status] = 2
where publisher_db = 'MarkedExpiredDB'
After i did reinitialization , all the rows are replicated but its again and again reinitializing please suggest.
Thanks,
Thanks,
Gangadhara MS
SQL Developer and DBA |
|
|
|
|
|
transactional replication