March 9, 2022 at 7:33 pm
Dears ;
Layout:
SQL 2019 publisher/distributor server (standard) with push subscribers (various versions, express)
Problem :
Multiple subscribers throw this alert every day in the publisher/distributor SQL errorlog:
The subscription(s) have been marked inactive and must be reinitialized. Nosync subscriptions will need to be dropped and recreated.
Settings :
Publication retention : 1440 hours
Distribution transaction retention : 0-744hours / history retention 168hours
Conclusion :
So I'd expect that this error would only happen if a subscriber is not syncing up within 744 hours (31 days). But there is something else going on it seems... far to many subscribers throw this error. Any ideas?
March 10, 2022 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 11, 2022 at 1:57 pm
In Publication properties, it is best to mark it as "Subscriptions never expire".
Also you could execute the below to bring it back to normal state.
USE distribution
GO
Update [MSsubscriptions]
Set [status] = 2
where publisher_db = 'YourDBName'
-Roy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply