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 |
|
Scott
Posting Yak Master
145 Posts |
 Posted - 2002-09-13 : 06:56:19
|
| When I create a new maintenance plan on one of my servers for backups the option to delete files older than x. The drop down list that should have days/weeks/months is populated with nothing.Is this a known bug? How can I fix?In the Job the execute step is as follows:EXECUTE master.dbo.xp_sqlmaint N'-PlanID AA39390A-D79A-42CB-9B41-ABB839AC52A0 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\Data\MSQL\Backup" -DelBkUps 4 -CrBkSubDir -BkExt "BAK"'What is the -DelBkUps 4 switch and should it have days/weeks or months after?Edited by - scott on 09/13/2002 07:33:50 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-09-13 : 14:38:43
|
| I created a couple of maintenance plans to see what it generated. The -DelBkUps 4 is, as you suspect, the "Remove files Older Than ___" information. my test maintenance plans put the word DAYS or WEEKS right next to the numer, so for instance it says:-DelBkUps 3DAYS |
 |
|
|
Scott
Posting Yak Master
145 Posts |
Posted - 2002-09-16 : 06:06:49
|
Thanks for that sorts the backup problem out. (Didn't even think to check it out on one of my other servers) Must have been having a "doff" Friday. (for those who don't know doff is a South African expression for (dumb, switched off, asleep ...) the o is pronounced the same as in off ie 'd-off') But does anyone know why in the GUI the dropdown list is not populated.Has anyone else heard of or experienced this? |
|
|
|
|
|
|
Backup Maintenance plan