January 24, 2012 at 11:30 pm
Hi,
i am getting this following replication error
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
Microsoft SQL Server 2008 R2 (RTM)
please suggest to fix this issue
Thanks in advance
January 25, 2012 at 6:38 am
Not enough info to help you here.
What type of replication do you have?
What was the sync method you used?
Did you stop the log reader agent turned of for a long time?
From what I see, the only thing you could do is reinitialize your subscriber DB using snapshot once again.
Just my 2 cents
-Roy
January 26, 2012 at 10:57 pm
Hi thanks for the reply
below is exact errror
DESCRIPTION: Error: 14151, Severity: 18, State: 1 Replication-Replication Distribution Subsystem: agent . The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
January 27, 2012 at 11:23 am
Its not really an error. Its pretty self explanatory. The subscriber has not communicated in the expiry period as dictated by your publication and the clean up job on the distributor has ran marking it as inactive.
It tells you what you have to do. Drop the subscription and re-add it. I recommend doing this by script.
If the data has NOT changed you will be able to resubscribe as no sync (@sync_type = 'none').
January 29, 2012 at 10:36 pm
thanks a lot
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply