Summary
In this chapter, you have been introduced to SQL Server 2005 replication. You have seen what replication can be used for, what makes up a replicated system, and the different types of replication. You have also learned the basics of configuring, managing, and tuning replication. It might seem difficult at first, but once you have set up replication a few times, you will see that it isn’t as hard as it first seems.
Although replication appears at first to run itself and doesn’t need any administration, it is important to monitor it regularly. Check the logs regularly, look for errors or problems, and correct them as soon as possible. Be sure to monitor the network and I/O subsystem as well as space on the publisher, distributor, and subscriber. ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
