O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required