• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3747
  • Last Modified:

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

0
jung1975
Asked:
jung1975
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
simply issue the following command to cycle the errorlog:
DBCC ERRORLOG

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
note: I have a job scheduled on my server to do this automatically every week/month.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now