from time to time my transactional (push) replications on SQL2000 SP3a servers send me the following error message:
Error Message : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.Error Detail : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: Server Name (Data source); Error number: 21074)
My subscriptions have been very active for at least 2 years and in the properties "Subscriptions never expire" is marked.
I know that I can restart replication by setting the status column in distribution..MSsubscriptions to 2 but can anyone tell me why this problem occurs and how I can prevent it in future?
Thank you for your help
I also got same error..I looked to the some forums on net and everybody say that its related with expiration time..its default 72 hours and it can be set longer.. What is that max value of expiration time?Actuallly I want to set my replication as never expired..I mean it should be never expired..How can I set expire time as "unlimited"..
Hey, not sure all of the steps that I took to resolve my issue, but here's what I recall:
Under Replication Monitor at the Distributer, expand node.
Expland node next to server name (Blue-green book icon)
Right click on any of the publishers and choose Reinitialize all subscriptions. (alternately, you can choose properties and select reinitialize under the Subscriptions tab). This just marks the subscription to be reinitialized.
Next, on Status tab, I clicked Run Agent Now to trigger the snapshot; this is supposed to, in my setup, push the subscription but that didn't happen.
Closing the properties window (if open), I selected the publisher in question so the information appeared in the right pane. Selecting the Publish Folder with the red X, I right clicked and chose Start Synchronizing.
That did it for me; hopefully, I chose the right setting in properties so it doesn't happen again.
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
I am getting this error frequently .. and it requires me to go through all the process of creating subscriptions again and again...
i would be happy if anybody help in this regard.
I have "Subscription Expiration perios set to 336 hrs" ... even if it is set to 336 hrs i am getting the above error frequently i.e., bfore this expiration period.
Also u might want to try to increase number of retries for replication jobs...