October 1, 2010 at 1:53 am
hello to all sql experts
good day!
i would like to ask some procedure/steps by steps screen shot setup for this type of topology coz i am novice for this subject. and this is also my new task. can anyone help me to configure this type of topology.
sorry for the mis spell of the title it is suppose to be transactional replication.
with central publisher with remote distributor topology.
thanks in advance
October 1, 2010 at 3:30 am
BOL has some good information:
http://msdn.microsoft.com/en-us/library/ms151866.aspx - "Configuring, Modifying, and Disabling Publishing and Distribution" - provides steps on how to do this using T-SQL, RMO and SSMS
http://msdn.microsoft.com/en-us/library/ms152503(v=SQL.100).aspx - "Creating, Modifying, and Deleting Subscriptions" - provides steps on how to do this using T-SQL, RMO and SSMS
http://msdn.microsoft.com/en-us/library/bb500348(v=SQL.100).aspx has information on how replication works and some things to consider when setting up replication
My recommendation would be to setup replication for the first time from the GUI - when doing this from the UI there is an option to generate scripts for everything that is done from the UI and these scripts can then be used to automate the process of replication setup.
Setting up replication with a central publisher and remote distributor is simple enough and you can use the steps provided in the links above to do the same.
The following links provide screenshots for replication setup:
http://www.informit.com/articles/printerfriendly.aspx?p=170234
http://www.informit.com/articles/printerfriendly.aspx?p=169612
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply