Areas of Maintenance

As a DBA, you should be concerned with five broad areas of maintenance:

  • SQL Server maintenance

  • Database maintenance

  • Table/object maintenance

  • Job maintenance

  • Windows maintenance

SQL Server Maintenance

The following list summarizes the types of maintenance that should be performed at the SQL Server database engine level:

  • Monitor error logs

  • Record configuration information

  • Manage logins

Monitor Error Logs

As a DBA, you should frequently review SQL Server's error log. When you review the error log, look for messages that do not appear under normal circumstances. Unfortunately, the error log contains more than error messages. It also contains statements about the status of events, copyright information, and so on. This means that you ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

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