Hello,
I've created a Maintenance Plan with a Backup Task and a Cleanup Task. The Backup task works fine, but not the cleanup task.
When I execute the maintenant plan, there's none error message but the old backup files aren't deleted.
Could you help me please?
Thanks
I was a bit puzzled by this as well, but then i read the help file:
- Backup and restore history
Retaining records of when recent backups were created can help SQL Server create a recovery plan when you want to restore a database. The retention period should be at least the frequency of full database back ups.
- SQL Server Agent Job history
This history can help you troubleshoot failed jobs, or determine why database actions occurred.
- Maintenance plan history
This history can help you troubleshoot failed maintenance plan jobs, or determine why database actions occurred.
So it actually makes a lot of sence that the back-up itself is not deleted, only the information in the database that says the back-up was made.
|||You may be running into the below issue.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=336728&SiteID=1
Backup task supports subfolder but cleanup task did not in RTM. This is addressed in SP1.
Let me know if this is not the issue you are running into.
Gops Dwarak
|||Oops,
Maintenance Clean-up Task != History Clean-up Task
My bad....
No comments:
Post a Comment