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

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 to point the errorlogs to the new place.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish