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.
March 4, 1999
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 :-
Fix the application(s) that are causing the errors.
NTFS compress the log directory to reduce the physical space it takes
Move the errorlog to another directory and use the -e startup option topoint the errorlogs to the new place.
You May Also Like