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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-21 : 07:19:33
|
| Robert writes "I am running Microsoft SQL Server 2000. I have maintenance plans created using the wizard to backup my user databases, the system databases, and the transaction logs. I have the -DelBkUps 5DAYS entered in the maintenance plans. The system database backup plan and the transaction log backup plan successfully delete any bak files older than 5 days, but the user database backup plan does not. The user databases are 4GB, 2GB, 0.6GB and 0.5GB in size. The system databases and transaction logs are much smaller. My hard drive is filling up after a few backups because the -DelBkUps is not working for the user database plan. Do you know of any reason why this one would be unsuccessful while the others work properly? Thank you for any help you can give me." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-21 : 11:34:17
|
| Did you check the job to see the script that's running? Maybe it's not part of it.Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-21 : 12:38:26
|
| Have you checked the maintenance plan through the wizard? Or did you not use the wizard? Permissions could be the issue, so you should check that. Is the job showing success even though it isn't running -DelBkUps?Tara |
|
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2003-12-03 : 15:38:05
|
| I am experiencing this exact same problem; the backup files are not being deleted after the number of days they should.the maintenance job runs fine and permissions fine (the file deletion USED to work but no more).did you ever resolve this issue?? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-03 : 16:39:55
|
| Try recreating the maintenance plan. I have seen them just stop working before.Tara |
|
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2003-12-03 : 16:43:14
|
| I was going to say "oh, great, ANOTHER Microsoft software bug" but thought better of it.MS SQL is one product I actually enjoy using and works pretty well.thx for the info. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-03 : 16:43:59
|
| Also, are you running service pack 3a? It could be a bug that was fixed in a later service pack.Tara |
|
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2004-01-01 : 15:36:34
|
| figured this one out.the problem was that I was resetting the Archive attribute of the backup files nightly so that I could see the files when I wanted to do a restore.unfortunately, this seems to cause a problem with the backup system so that the files did not get deleted.make sense now, sort of. |
|
|
|
|
|
|
DelBkUps fail