Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2009-05-19 : 14:04:56
|
| In the server that I installed the SQL Server2005, I found a lot of .txt files in folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. They are log files created each time by the job running in the Jobs of SQL Server Agent and stay in there since the jobs started to run. One of the file is like this:TestingServer Maint_Hourly Transaction Log Backup_20081015080209.txt.I don't want to keep them forever, and set up a job to perform a Clean up plan with a "Maintenance Cleanup Task" to delete the txt files in this folder. But, the job is always successful, and the files are not deleted.Now, the folder is already 250MB. How can I setup something to delete them over 2 weeks old?Thanks. |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-19 : 23:42:59
|
| The maintenance task should clear these up.....make sure you got permissions to clean them up and pointing to the right folder. |
 |
|
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2009-05-27 : 17:16:10
|
| Thank you TRACEYSQL,Yes, I set correct permission to the folder and the task was pointed to the right folder.As a test, I changed the Delete files to Backup files, and changed the File extension to bak or trn, also I copied some .bak and .trn files to the same folder. Both .bak and .trn files were successfully deleted in 2 tests.But, when I change it back to "Maintenance Plan text reports" in Delete files of and txt in File extension, the job still runs successfully, but the .txt files are not deleted.Why? |
|
|
|
Barakanooz
Starting Member
2 Posts |
Posted - 2009-09-24 : 15:11:59
|
| Same problem here have you ever found anything on this? |
|
|
|
Barakanooz
Starting Member
2 Posts |
|
|
|
|
|
|
|
How to delete the txt files in \LOG