posted on Monday, April 03, 2006 4:13 AM
by
mz1313
HowTo: delete old backups as part of maintenance plan in SQL Server 2005
In SQL 2000 there is nothing easier then that - just choose required options in the Complete Backup and/or Transaction Log Backup tabs. In SQL 2005 those who try to create Maintenance Plan using a wizard, usually ask aftewards, where did they miss the "delete old backups" option. The answer is: nowhere. There is no such option in a wizard. In order to delete old backups one should open existing plan (created with a wizard, for example) in SSIS window (open Management Studio, Management --> Maintenance Plans, right click on your plan --> Modify) and add "Maintenance Plan Cleanup" task.