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 |
|
ddamico
Yak Posting Veteran
76 Posts |
 Posted - 2008-12-08 : 09:24:15
|
| I have SQL Server 2005 SP2 x64 installed. I have created a generic task to be used to remove maintenance logs older than 2 weeks.The job says has completed successfully and the log indicated success but it doesn't seem have removed any files. I am wondering if its only trying to remove files that match the name of the job or its trying to remove all files in the specified folder with "txt" extension.Does anyone have a thought? Thanks |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2008-12-08 : 09:54:59
|
| Double check you configured the task to delete files with 'txt' and not '.txt' |
 |
|
|
ddamico
Yak Posting Veteran
76 Posts |
Posted - 2008-12-08 : 10:05:43
|
| As I have done some Googling it seems that this is a known bug. I am reading it will cleanup bak and trn files but not txt files. I did check the extension right off. According to KB articles release 3175 addresses this. I am going to test this in my test SQL box. If I get the same results I am going to upgrade test version if SP3 and rerun the test to verify if this will fix it. I will let you know my finding.s |
|
|
|
ddamico
Yak Posting Veteran
76 Posts |
Posted - 2008-12-08 : 14:10:27
|
| After installing SP3 in our testing environment and running the job the maintenance log files "txt" now are removed. Perfect. |
|
|
|
|
|
|
Maintenance Jobs Questions