As a DBA, you should be concerned with five broad areas of 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
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 ...