May 4, 2012 at 9:30 am
I am having issues with setting up Databases for Replication. When I setup a Publication and Subscriber the MSubscriptions table has a status of 3 for the database just created.
select publisher_database_id, publisher_id, publisher_db,
publication_id,article_id, subscriber_id,
subscriber_db, status
from MSsubscriptions
I searched online and got a solution to ‘Drop Replication Completely’ which I prefer not to do since 25 databases are already setup correctly with the status of 2. Can I just update the table and change the Status to 2?
Any ideas/suggestions?
May 7, 2012 at 3:44 am
Try "update distribution..MSsubscriptions set status=2 where subscriber_db='your DB' ".
The blog here (http://blogs.imeta.co.uk/jwatson/archive/2008/09/22/error-in-replicationsubscriptions-have-been-marked-inactive-and-must-be.aspx) says its is absolutely safe to update the status, I havent personally tried it ever though.
May 7, 2012 at 4:06 am
tkathpalia (5/4/2012)
I am having issues with setting up Databases for Replication. When I setup a Publication and Subscriber the MSubscriptions table has a status of 3 for the database just created.
1) What is the "actual" issue? Why did you check MSsubscriptions table?
2) Are is sure status is 3? Because as per BOL it can have only 0/1/2. It cannot be 3.
May 7, 2012 at 9:17 am
The database's status is set to 3, every time I create a database for Publication and Subscription. Some of the forums mentioned to check the table for the Status.
Has anyone just changed to Status to 2? Any other solutions if one feels that updating the table to change the status is not a recommended.
May 10, 2012 at 10:54 am
As stated earlier... What is the problem? If replication is working, don't do anything. And certainly don't go updating tables when you don't know what it will affect, that's just stupid.
Jared
CE - Microsoft
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply