Viewing the Error Log with the Enterprise Manager 

Procedure

  1. In the the Enterprise Manager, expand the server, Management and SQL Server Logs.

    2. All the currently available logs are displayed.

  2. Choose the error log that is of interest to you. This might be the Current log or one of the archived logs. The date beside the log indicates when it was archived.

The messages in the log are displayed in the right-hand pane. You can display the last six logs in the Error log menu.

A new error log is created each time SQL Server is started. SQL Server retains backups of the previous six error logs. If the log file name is E:\MSSQL7\LOG\ERRORLOG, the last 6 log files are archived under the following names:

E:\MSSQL7\LOG\ERRORLOG.1
E:\MSSQL7\LOG\ERRORLOG.2…
E:\MSSQL7\LOG\ERRORLOG.6

Each time the SQL is started, the archived oldest log files are overwritten and are lost, unless you save them first. If you have a serious problem, you should immediately save these files otherwise they will be lost.