how to setup central publisher replication

Question

Post reply

how to setup central publisher replication

deep_kkumar

Hall of Fame

Points: 3243
More actions
December 26, 2011 at 10:05 pm

#262221

Hi,
I am having trouble in setting up central publisher replication. I am having hard time to add another subscriber to the publisher. I am looking for a step by step process. Is central publisher possible for pull subscription?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

How to: Create a Publication and Define Articles (SQL Server Management Studio)

http://msdn.microsoft.com/en-us/library/ms151160.aspx

How to: Create an Updatable Subscription to a Transactional Publication (SQL Server Management Studio)

http://msdn.microsoft.com/en-us/library/ms152769.aspx

deep_kkumar Hall of Fame Points: 3243 More actions · Answer 2

Dev (12/26/2011)
How to: Create a Publication and Define Articles (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms151160.aspx
How to: Create an Updatable Subscription to a Transactional Publication (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms152769.aspx

Thanks Dev.

I know how to create publications. I am looking for one publisher multi subscriber replication steps.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 3

You can use sp_addsubscription fo0r each new subscriber you have.

-Roy