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: 931 times
Last Updated: Aug 16 '12 at 06:41 AM
Replication Hardware Requirements
Database design with P2P replication
SQL Server Replication Between Two Different domains.
How to enable Oracle Subscrition for MSSQL Publisher
what's happening when my replication distributor server outage?
"The process could not bulk copy into table" getting this error for a particular table in replication.
Change transactional replication from every 15 min to continuos