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, 2012 at 04:38 PM in Default

avatar image

140 37 42 45

Yes that is right.

Aug 15, 2012 at 04:48 PM Chitrarekha

Were the answers in that post not informative enough?

Aug 15, 2012 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, 2012 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, 2012 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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Aug 14, 2012 at 04:38 PM

Seen: 959 times

Last Updated: Aug 16, 2012 at 06:40 AM

Copyright 2018 Redgate Software. Privacy Policy