Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication__Distributor Expand / Collapse
Posted Wednesday, January 30, 2008 9:36 PM


Group: General Forum Members
Last Login: Tuesday, August 12, 2008 2:53 PM
Points: 18, Visits: 308
hi all I have a replicatoin problem, I have single publisher and multiple subscribor. Now one of our
server gives an error which says that

Subscriber has markend inactive and must be reinitalized.

Now I have created the snaphot for the subscriber and ran the logreader agent now my problem is if I reinitalize the
subscription will it going to effect the other subscription which is already running.

I would be highly thankful if you guys help.

thank you.
Post #449793
Posted Friday, February 1, 2008 8:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 2, 2016 8:30 AM
Points: 1,243, Visits: 759

The snapshot will only be applied to the subscriber that has been reinitialized (unless it is Snapshot replication)

The logreader will continue to process records for the other subscribers.


Post #450563
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse