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: 927 times
Last Updated: Aug 16 '12 at 06:41 AM
SQL Server Transactional Replication - Schema change failed on object - Snapshot agent is not running
How to Synchronize Client-Server Database with WebServer Database using replication?
Should I set the subscriber in transactional replication to read-only?
Replication - Can log backups interfere with transactional replication?
Can SQL Server 2000 replicate system databases and/or logins?
Whats the best way to replicate data without data loss between more than 2 databases
Replication Monitor error
Queue Reader Error