GordonAluminum
asked on
Maintenance Plan does not clean up old Backup files
on SQL Server 2000 I have a maintenance Plan setup for doing transaction and full backups. I have it set to keep one backup file. Periodically it does not delete them for days at a time. Is this a bug or is there something I can do to fix it? Also is it fixed in SQL Server 2005?
MaintPlan.jpg
MaintPlan.jpg
RDWaibel
I had this issue in 2000 as well. I just created a VB app to keep them clean. I have not noticed this as an issue in 2005
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have noticed that this mechanism doesn't work well, especially not when there's a gap between dates of these files.
In SQL 2005 it was broke (worse than SQL2000 IMHO) until at least SP2. There were huge bugs in the maintenance plan functionality, and it has been partially rewritten between RTM and SP2. It is very difficult to troubleshoot these plans when they fail. At least it offers to look at the T-SQL syntax and cut and paste it, so you could execute the statement and check whether it works. It's so unreliable that Siemens has it's own mechanism for some healthcare and financial suite, called SDMF. That works rather well.
In SQL 2005 it was broke (worse than SQL2000 IMHO) until at least SP2. There were huge bugs in the maintenance plan functionality, and it has been partially rewritten between RTM and SP2. It is very difficult to troubleshoot these plans when they fail. At least it offers to look at the T-SQL syntax and cut and paste it, so you could execute the statement and check whether it works. It's so unreliable that Siemens has it's own mechanism for some healthcare and financial suite, called SDMF. That works rather well.