x

Creating separate distribution database in sanpshot replication

I am using the following link to setup snapshot replication http://www.databasejournal.com/features/mssql/article.php/1458491/Setting-Up-Snapshot-Replication-A-Step-by-step-Guide.htm I have sqlserver 2008r2 on a windows 2008 server. I would like to create the distribution database on a different server to potentially reduce the over-head at the publisher. In order to build that do I use the distribution database on server A, Publication database on Server B (where the database resides) and connect to Server C for the subscriber database?
more ▼

asked Aug 14 '12 at 04:38 PM in Default

Chitrarekha gravatar image

Chitrarekha
140 30 38 43

Yes that is right.
Aug 15 '12 at 04:48 PM Chitrarekha
Were the answers in that post not informative enough?
Aug 15 '12 at 10:07 PM sp_lock
Not quiet. I wanted to know I could build separate distribution database, publisher database where the database resides and Subscriber database on another server.
Aug 16 '12 at 03:07 AM Chitrarekha

I would advise you update all of your questions so that other people landing on the site know if the help given was useful.

Also, use the comments when replying.
Aug 16 '12 at 05:23 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x293

asked: Aug 14 '12 at 04:38 PM

Seen: 683 times

Last Updated: Aug 16 '12 at 06:40 AM