Maintenance Cleanup Task……

SQL Server 2005 Standard Edition

Windows Server 2003.

I have created an ‘Backup Database Task’ to create the database backups and checked the option “Create a subdirectory for each database”.

When I add the “Maintenance Cleanup Task” I am not getting the similar option to clean the backup files in the subdirectory.

Any suggestion on how to solve this?

I can always uncheck the “Create a subdirectory for each database” option to create the backup files in one location.

Thank you,

Smith

Smith,
Once you create a Sub directory the backup files will be placed there...now in the clean up task there is an option called "Search folder and delete files based on an extension" you need to specify the sub directory folder in the above mentioned option........the clean up task will delete it and also you need to psecify the extension as "bak" to delete backup files.........refer the below link,
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p2.aspx

|||

This article could be helpful for you

http://msdn2.microsoft.com/en-us/library/ms345177.aspx

|||

Deepak,

This link says...

"To delete the first-level subfolders, you must explicitly elect to do this by checking the Include first-level subfolders option in the Maintenance Cleanup Task dialog box."

I am not finding the "Includefirst-level subfolders" option to check.

How to check this option.

Thank you

-Smith

|||

Hi,

What Service Pack are you on? You should be getting that option when you Edit the Maintenance Plab Sub-task "Clean up Maintenance Task"

|||

select @.@.version

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Thanks,

|||Try to install SQL 2005 SP2 critical update from
http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

refer the below link,
http://support.microsoft.com/kb/933508 as there were many problems relating to maintenance plan which were fixed with critical update ! ! !
|||

Thank you for your suggestions in resolving this issue.

Since it is not a critical issue affecting the production I will wait for the SP3 :-)

Infact when I installed the SP2 I did download the latest copy available.

Thank you,

|||Well i don't think SP3 would be released for sql 2005 as sql 2008 is going to be released in Feb 2008