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 |
|
suemeyer51
Starting Member
3 Posts |
 Posted - 2008-07-31 : 18:32:30
|
| I have created many different maintenance plans - some using the wizard and some not using the wizard. I finally was able to figure out how to delete the bak files but can't seem to delete the subplan txt files.Any thoughts? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-31 : 18:39:36
|
| Use maintenance cleanup task and select delete maintenance txt supreport files. |
 |
|
|
suemeyer51
Starting Member
3 Posts |
Posted - 2008-07-31 : 19:10:25
|
quote:
Originally posted by sodeep
Use maintenance cleanup task and select delete maintenance txt supreport files.
that's what I was trying and it doesn't seem to delete any of my subplan txt files. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-31 : 20:58:26
|
| You can only choose one at a time. |
|
|
|
suemeyer51
Starting Member
3 Posts |
Posted - 2008-07-31 : 23:11:41
|
quote:
Originally posted by sodeep
You can only choose one at a time.
I only had this delete in the job and it still doesnt work. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-31 : 23:16:47
|
| That's correct, it doesn't work. Don't know why Microsoft didn't fix it after 2 sps plus so many fixes. I put it in bug report and they said will fix it in next version. Didn't get chance to test it in sql2k8 yet. |
|
|
|
|
|
|
Cant delete SQL Server 2005 subplan txt files