SQL Server Log - The SQL Server Error LogThe SQL Server Log or SQL Server Error Log is one of the most important logs and can be used hand-in-hand with other Windows Event Logs.
The problem on a busy server is that it can fill up quite quickly. Id advise running a standard maintenance stored procedure once a month containing the following...
Then the errorlog only contains one months worth of information and can be viewed quite easily. Ive known error logs to become so big that you cant view the information inside.
If you have a regular restart policy this isnt a problem as a new log is built. It would be wise to save all logs that get overwritten or extend how many logs are kept. A future tool methinks.
These are stored in the \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log folder.