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 |
|
Expekt
Starting Member
3 Posts |
 Posted - 2007-04-13 : 07:13:38
|
| We have a SQL 2000 server with the latest servicepacks installed. Our maintenance plan failed because the disk space was to low. I have deletes lots of files to free up disk space, so that should be OK now.The maintenance plan should delete files older than 3 days, but the first failure it doesn't delete files anymore, it just keep on saving all backup files. The result being low disc space after a few days. I have experienced this behaviour earlier also, and the only solution I have yet is to delete the mainenance plan and create a new one. Then it works fine again. Does anyone have another solution to this problem? |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2007-04-13 : 09:55:34
|
| Have you thought about making your own backup script and running it from a SQL job? Tara has some nice ones already made. Check hers out at: http://weblogs.sqlteam.com/tarad/. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-13 : 10:52:59
|
| Did you check plan's log file to see why it didn't delete old files? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-13 : 11:07:38
|
We have Maintenance Plans on two servers that never delete their Tlog backups, and always report Failure. I've never discovered the cause, but it is possible that both of them became full at some point."Did you check plan's log file to see why it didn't delete old files?"hahaha ... I've never found a useful diagnostic message as to why a Maint.Plan failed  Kristen |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-04-13 : 12:28:44
|
| I'd prefer the scripts over the plans, as well.The log files kind of stink for that. I'd check the plan history table instead. At least you'll get a better description than "SQLMaint failed". |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-13 : 12:49:35
|
| I found if any steps in the plan before deleting file failed, the plan will not delete old files. That's why I always check plan's log file first. |
|
|
|
|
|
|
Maintenance plan fails after low disk space