Is the distribution database always created where the publication database is created. I have about 13 databases on the server and they will be replicated using snapshot replication.
asked Aug 10, 2012 at 08:44 PM in Default
The distribution can be created on a different server to potentially reduce to over-head at the publisher.
Currently I have 18 DBs that use the same distribution DB (hosted on the same SQL instance), but it does have its own data/log array.
answered Aug 11, 2012 at 02:46 PM