We help IT Professionals succeed at work.

Delete ErrorLog file in sql server

jung1975
jung1975 used Ask the Experts™
on
How can i delete the errorlog file in sql server 2005?

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

I am trying to delete the errorlog file becasue it's huge..

but it keep giving me an error: it's beging used......

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
simply issue the following command to cycle the errorlog:
DBCC ERRORLOG

Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
note: I have a job scheduled on my server to do this automatically every week/month.