O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required