Delete ErrorLog file in sql server

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......

jung1975Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
note: I have a job scheduled on my server to do this automatically every week/month.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
simply issue the following command to cycle the errorlog:
DBCC ERRORLOG

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.