SQL Server Replication

SQL Server replication allows database administrators to distribute data to various servers throughout an organization. You may wish to implement replication in your organization for a number of reasons, such as:

• Load balancing. Replication allows you to disseminate your data to a number of servers and then distribute the query load among those servers.
• Offline processing. You may wish to manipulate data from your database on a machine that is not always connected to the network.
• Redundancy. Replication allows you to build a fail-over database server that’s ready to pick up the processing load at a moment’s notice.

http://databases.about.com/cs/sqlserver/a/aa041303a.htm

•