Error Message:
Replication-Replication Distribution Subsystem:
agent DBA\DBA-EPDW-EPDW-DB6C\DB6C-5 failed. The subscription(S) have been
marked inactive and must be reinitialized. NoSync subscriptions will need to be
dropped and recreated.
At publisher:
============
use distribution
go
STEP 1: select * From
distribution..MSsubscriptions
P.S: Note down publisher_id,
publisher db name, publication_id , subscriber_id and subscriber_db name of
whose status is 0
Status of the subscription: 0 = Inactive; 1 =
Subscribed; 2 = Active
subscription_type 0=PUSH, 1=PULL
STEP 2: Update Status to 2
if exists (select 1 from distribution..MSsubscriptions where
status = 0)
begin
UPDATE distribution..MSsubscriptions
SET STATUS = 2
WHERE publisher_id = '--publisher_id -- will be integer --'
AND publisher_db =
'--publisher db name ---'
AND publication_id
= '--publication_id -- will be integer --'
AND subscriber_id
= '--subscriber_id -- will be integer ---'
AND subscriber_db
= '-- subscriber_db ---'
end
else
begin
print 'The subscription is not INACTIVE.. you are good for
now .... !!'
end
STEP 3: Right click
on subscriber and choose view synchronizing status
STEP 4: Click Start
STEP 5: Observe the
replication monitor for any issues, if no replication is in Sync.
To review pending commands to
replicate. At publisher:
========================================================
use distribution
go
exec sp_browsereplcmds
Thanks a lot for this perfect solution! It saves me hours of work!!
ReplyDeleteWelcome. :) Glad to hear !!
ReplyDeleteWill this not get the subscriber database out of sync with primary??
ReplyDeleteHello Juhi,
DeleteBy bouncing log reader agent subscriber will not go out of sync. Thanks,
After Performing all the steps above I am still getting the same error. What can be the reason and what other things I need to check to fix it. Please suggest
ReplyDeleteThanks, Great Solution...
ReplyDeleteThank you for this! After spending some time searching for the answer this article gave me exactly the information I needed to resolve the problem.
ReplyDeleteThanks! Glad to know.
DeleteThank you for this
ReplyDeleteWelcome
Deletethank, you saved my day
ReplyDeleteThank you!!
ReplyDeleteI found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work... rewriting history
ReplyDeleteThanks once again!!
DeleteBut why this breaks? what is the reason? any help please
ReplyDeletethanks it works for me...appreciate it.
ReplyDelete