My SQL Server errorlog is filling up with entries. How can I switch or truncate it?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. There is no way to truncate the errorlog or switch it either,short of stop/starting the MSSQLSERVER service.

If the errorlog is filling up your disk then your choices are :-

  1. Fix the application(s) that are causing the errors.

  2. NTFS compress the log directory to reduce the physical space it takes

  3. Move the errorlog to another directory and use the -e startup option topoint the errorlogs to the new place.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like