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 distributionUpdate [MSsubscriptions]Set [status] = 2where publisher_db = 'MarkedExpiredDB'After i did reinitialization , all the rows are replicated but its again and again reinitializing please suggest.Thanks, Thanks,Gangadhara MSSQL Developer and DBA |
|
|
|
|
|
transactional replication