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.
Aug 10 '12 at 08:44 PM
I am using the following link to setup transactional replication. http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/3/. I have sqlserver 2008r2 on a sqlserver 2008 server. Do I use the distribution database on server A, Publication database on Server B and connect to Server C for the subscriber database?
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.
Aug 11 '12 at 02:46 PM
I think the detail of your answer is the key - the Distribution database needs to be configured for high performance if it is likely to be crucial to an environment that is busy. It will work on the same instance or a different one but can perform badly in either if the settings are not considered and configured to be optimal
Its always hard to comment with limited info. It could be 13 replicated DBs on FusionIO cards. But MS do suggest sep arrays for performance.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Aug 10 '12 at 08:44 PM
Seen: 435 times
Last Updated: Aug 16 '12 at 06:41 AM
How to query synchronization status for push transactional replication
SQL Server 2005 replication. : "Change sa password breaks replication"
When is a published database not published?
Cannot Add Replication to SQL 2005 Express
Query to find Table schema modification who used in Replication
unable to configure Distribution
Replication with Oracle and SQL Server 2008
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.