Replication: SQL Server 2000 - Part 1
(Page 1 of 7 )
In this first installment of a 2-part series, Mahesh describes and explains what Replication is, its features and benefits, and how you can put it to use.
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.
Next: Replication Benefits >>
More SQL Server Articles
More By Mahesh Kodli
/ 185 
