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 |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2008-02-25 : 15:04:19
|
| I have a maintenance plan setup to expire backup sets after 4 days, but its keep backup copies for an infinite amount of time. I might be misunderstanding whats suppose to happen, but I would expect the files to be removed after 4 days. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 15:41:54
|
| Then you need to set plan clean up subplan. |
 |
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-02-25 : 15:49:45
|
| Not sure I understand, sorry for my ignorance. I understand about subplans, not sure what task I would tie to a subplan to do the cleanup?? |
|
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-02-25 : 15:51:02
|
| Found the maintainence cleanup task, nevermind |
|
|
|
|
|
|
Backup sets to expire