Link to home
Start Free TrialLog in
Avatar of jung1975
jung1975

asked on

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

Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

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

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial