TechRepublic : A ZDNet Tech Community

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

Tags: Database, Microsoft SQL Server, Microsoft SQL Server 2005, Joshua Hoskins, Gallery, screenshots, how do I, replication, databases, sql server

  • Save
  • Recommend
  • 1

By Josh Hoskins

Replication folder

By Josh Hoskins<br /><br />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.
                                       

Print/View all Posts Comments on this gallery

peer to peer transaction replication configuration on 2 sql servers 2005 rabisahu3@... | 05/16/08

What do you think?


SmartPlanet

Click Here