Configuring Replication in 2012

Question

Configuring Replication in 2012

jjolk

SSC-Addicted

Points: 431
More actions
November 21, 2012 at 9:34 am

#267079

I know I'm missing something obvious, but I'm trying to learn about Replication and all the documentation I read says to right click on the "Replication" node in SSMS and select "Configure Distribution" and a wizard will start. I don't have "Configure Distribution" as an option in the menu after righ-clicking. Did I set something up wrong during my install?

Viewing 6 posts - 1 through 5 (of 5 total)

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

kvishu83 SSC Eights! Points: 848 More actions · Answer 1

If publication already exists, Configuration distribution option is not available.So, Check if you have any publication configured and also for distribution DB under system databases list.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 2

jjolk (11/21/2012)
I know I'm missing something obvious, but I'm trying to learn about Replication and all the documentation I read says to right click on the "Replication" node in SSMS and select "Configure Distribution" and a wizard will start. I don't have "Configure Distribution" as an option in the menu after righ-clicking. Did I set something up wrong during my install?

When you right-click Replicatoin in SSMS you will either have the option to Disable Publishing & Distribution or an option to Configure Distribution. In short, the latter is for turning replication on, the former is to turn replication off*.

If this is a learning excercize and you are dealing with a sandbox then I suggest Disabling Publishing & Distribution first... You will then have the option to Configure Distribution.

My advice: as you are learning Replication make I highly suggest you start with at least two instances/servers if possible. You can setup replication where the distributor, publisher and subscriber are all on the same box/insance but this will not expose you to any of the real-world challenges you will encounter when dealing with Replication (e.g. G:\....\repl_data is a great folder for snapshots until you attempt to create a subscription on a new server). Get comfortable with snapshot replication first before messing with transactional, get comfortable with transactional before learning merge replicatoin.

Lastly: the Replication Stairway[/url] is awesome if you are just getting started with Replication.

Edit: Added Stairway link...

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

jjolk SSC-Addicted Points: 431 More actions · Answer 3

This was a very helpful post. Thank you for the advice as well.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 4

No problem.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Suresh B. SSC-Insane Points: 22986 More actions · Answer 5

jjolk (11/21/2012)
Did I set something up wrong during my install?

Yes.

While installing you need to select Replication component.

You can run setup program again and add replication component to an existing SQL Server instance.