Data Management

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

By Josh Hoskins

Replication folder

This gallery is also available as a TechRepublic blog post and download.

Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical administrative tasks. This How do I... shows you how to configure replication between two Microsoft SQL Server 2005 systems using the SQL Server Management Studio.
First you will need to connect the database engine that contains the data you wish to replicate in SQL Server Management Studio. From there you will need to right click on the Replication folder and select Configure Distribution.