August 19, 2009 at 7:58 am
I am trying to clean some space and I don't know what are these, can I delete them?Thank you
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG – 2.27GB of files
C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\LOG – 3.23GB of files
August 19, 2009 at 9:06 am
Krasavita (8/19/2009)
I am trying to clean some space and I don't know what are these, can I delete them?Thank youC:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG – 2.27GB of files
C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\LOG – 3.23GB of files
You havent listed the file extensions or filenames but I wouldnt delete them. You should think very carefully before deleting any files within C:\Program Files\Microsoft SQL Server or any of its sub directories.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 19, 2009 at 9:18 am
These folders are where the error log files are stored for SQL Server. What you can do is check how many you have and decide if you can delete old ones. You also might have maintenance plan or other log files stored there.
You can delete all but the current file, but make sure that you don't need them. If the current file is huge, and it will be if you rarely reboot, you can use sp_cycle_error_log to start a new one and then you can delete the old one.
August 19, 2009 at 12:26 pm
Just a correction,
The correct command is:
sp_cycle_errorlog
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply