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