Forum Discussion
How to delete backup maintenance plan ( Backup Every 3 Hrs.)
Hi . I want to delete backup in maintenance cleanup task more than 6 Hours
(My SQL Backup Every 3 Hrs.)
How can i set delete plan? I had changed delete files base on the age of the file at task run time
to be 6 Hours . but not work .now deleted files backup manuals
Thank you
Hi oliver076
there are multiple ways to delete the old backups files in SQL Server
Check this post for multiple options including the use of the maintenance plan wizard
oliver076 , your post is not very clear, because you provided very less informations.
Using a Maintenance Cleanup Task (Maintenance Plan) to delete old backup files works for me and others.
If it don't work for you, you setup something wrong; can say what, because of the missing information from your side.
Olaf
Hi oliver076
there are multiple ways to delete the old backups files in SQL Server
Check this post for multiple options including the use of the maintenance plan wizard
I think you can do it like this：
1. Open the backup tool or management platform. This may be a backup software, a cloud service provider's console, or a database management system's administration interface.
2. Navigate to the Settings or Configuration section of the backup maintenance plan. Typically, you can find the appropriate settings in the menus or options of the management interface.
3. Locate the current backup maintenance plan and choose to delete or edit it. This may involve selecting a specific backup task or plan and clicking the corresponding Edit or Delete button.
4. If you choose to edit a backup maintenance plan, you will be taken to a screen where you can change the backup frequency and other related settings.
5. In the Backup Frequency or Schedule Interval section, change the backup frequency from Every 3 hours to Every 6 hours. This may involve changing the numbers or selecting a new interval option.
6. Once you have completed the changes, save and apply the new Backup Maintenance Plan settings.
Hope it can help you
