
The error log is a central file in which all the important actions and error messages concerning the database are recorded. The database administrator should examine the log every day in order to detect any errors that might have occurred as early as possible.
For more information about error messages in SQL Server, see the SQL Server Books Online
For more information about viewing the error log, see the following sections: