Designing a Replication Strategy
Replication is another method of working with data at remote sources. SQL Server 2005 provides several methods of replication technologies so that you are able to copy and distribute your database objects among several databases and to multiple locations. The initial philosophy of replication is to enable the data to be close to the user. From this philosophy, many technologies have come forth that answer such questions as these: How fresh is the replicated data? How much bandwidth is available? How often is the original data updated? Can the user at the replicated site update the data? Is the data centrally located? Can the user at the replicated site just update the data belonging to that site and have read ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
