Data Management

How do I... Configure transactional replication between two SQL Server 2005 systems?

Distribution server

Next you will select how you want to select your distribution server. In most small replication environments using the server that hosts the data as your distributor is fine. However, if you are replicating large amounts of data on very busy servers, you may wish to set up a dedicated box to be your distribution system. This individual distribution system can be the distributor for multiple SQL Servers if you have that need.