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 |
|
DMcCallie
Yak Posting Veteran
62 Posts |
 Posted - 2007-08-16 : 10:17:10
|
| I am running 2005 SP2 (It is the SP2 refresh as I downloaded the SP2 on 3/15/07) and I can't get the .txt maint plans to delete. The job completes successfully; however, the old .txt files are still there. I found this technote: http://support.microsoft.com/kb/938085although I don't receive the error message in the KB. The report does have "New Component Output" as the 1st line in the report. I still don't see how deleting the 1st line of an already run job (the report) will affect a new run of the job.Also, I checked the version of the Microsoft.SqlServer.MaintenancePlanTasks.dll and it is at 9.00.3043.00 (which is the SP2 Refresh) in KB 933508 ( http://support.microsoft.com/kb/933508 ).I have several SQL/2005 servers and they all have this problem. Any help would be appreicated...Thanks,DeWayne |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 22:52:47
|
| Apply post sp2 hotfixes. |
 |
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2007-08-17 : 14:18:58
|
| Will the post hotfixes resolve the issue or is that just a guess? I have read the KB articles and it appears that the post hotfix for the maint plans is included in the SP2 refresh... I wondered about trying the post hotfixes. Has anyone else had this issue? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-17 : 23:57:25
|
| There are several post sp2 fixes to address maintenance plan issues. I don't see that problem on my servers by the way. |
|
|
|
|
|
|
2005 Maint Plans .txt files not deleting?