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