Viewing the SQL Server Error Log

You can also view the SQL Server error log by using any text editor. By default, the error log is \SQL60\LOG\ERRORLOG.

When SQL Server is configured to use its error log, each SQL Server session creates a new log, and SQL Server retains the last six logs created. The current log has no filename extension. The old logs are distinguished by their filename extension (.1, .2, .3, and so on), with the lowest number being the most recent log.

If the server was successfully installed, you can also view the error log by using SQL Enterprise Manager.

    To view the SQL Server error log using SQL Enterprise Manager

1. From the Microsoft SQL Server 6.0 program group, start SQL Enterprise Manager.

   The SQL Enterprise Manager window appears.

2. From SQL Enterprise Manager's Server Manager window, open a server group and select a server.
3. From the Server menu, choose Error Log.

   The SQL Server error log appears.

   

When SQL Server is configured to use its error log, each SQL Server session creates a new log, and SQL Server retains the last six logs created. The current log has no filename extension. SQL Server maintains the last 6 error logs created. The old logs are distinguished by their filename extension (.1, .2, .3, and so on), with the lowest number being the most recent log.