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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 transactional replication

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
   

- Advertisement -