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
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
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.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Aug 10 '12 at 08:44 PM
Seen: 729 times
Last Updated: Aug 16 '12 at 06:41 AM
FK Constraint Missing from Subscriber - Why?
checking replicated tables
Replication without overwriting DBO permissions
Could not drop article. A subscription exists on it. transactional replication
Can I tell if is safe to promote a mirror database to principal without a witness?
Publication and Subscription Properties
Replication on SQL 2005.
What is a distributor?
Queue Agent Reader Error
Sql Server 2005 Replication