Replication: SQL Server 2000 - Part 1 (Page 1 of 7 )
Database management systems are among the most important software systems driving the information age. In many Internet applications, a large number of users who are geographically dispersed may routinely query and update the same database. In this environment, the location of the data can have a significant impact on application response time and availability. A centralized approach manages only one copy of the database. The centralized approach suffers from two major drawbacks:
Performance problems due to high server load or high communication latency for remote clients.
Availability problems caused by server downtime or lack of connectivity. Clients, in portions of the network that are temporarily disconnected from the server, cannot be serviced.
These issues would be effectively answered by Replication.
Replication is the process of sharing data between databases in different locations. Using replication, you create copies of the Database and share the copy with different users so that they can make changes to their local copy of the database and later synchronize the changes to the source database.