Creating and Implementing a Maintenance Strategy for Database Servers

As a DBA, it is your responsibility to ensure that your SQL Server 2005 solutions are reliable, robust, and performing—and a million other things as well. Many techniques and tools can aid you in the everyday running, maintenance, and documentation required for the daily administration of a SQL Server 2005 instance.

The more professional organizations that use SQL Server adopt proactive management techniques to mitigate the impact on business that unpredictable performance problems, database corruptions, faulty hardware, and other such problems can cause.

Although it will depend on your infrastructure and environmental circumstances, generally most organizations perform a number ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.