Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding new subscriber to existing transactional replication setup Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 7:28 AM
Points: 2, Visits: 290
I have a Transaction replication setup between
Server A – Publisher
Server B - Distributor and Subscriber which is running fine without any issues.
I have a scenario where we need to add a another subscriber Server 3 to the exisisting replication process.
I could able to add a subscription at the publisher using
exec sp_addsubscription
Created a new subscription at the subscriber using the commands
exec sp_addpullsubscription
exec sp_addpullsubscription_agent
Problem is, I am not sure of creating a snapshot for the new subscriber, I could see only one Snapshot agent on the Distibutor, In case if I restart the snapshot I think it will disturb the existing replication process between Server A and B.
Is there any way we can create the new snapshot for only new subscriber.
Post #1421507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse