Maintenance Cleanup Task in SQL 2005

andy18    SQL-related    

I was checking on one of the MS SQL 2005 Workgroup server today and notice that the disk usage for the server has been used up for more than 50%. It really shocks me! Taking a closer look from the server side, it turns out that the previous Maintenance plan which has been setup to automatically delete the old backup does not have all the backup files deleted as it should.

Done some ‘Googling’ and apparently that there are known issue for the MS SQL 2005 maintenance cleanup task. Some of the options are :

1. Make sure you are running at least MS SQL 2005 SP1 ( at this moment SP2 has been released )
2. The extension file name in to be check for your Maintenance Cleanup task should be *.* instead of .bak / .txt

If you enjoyed this article please consider sharing it!