This month I have a minor update to the Rules-Driven Maintenance code I originally posted back in August 2012. This update has just two enhancements, but they are nice ones, I think:
- Much improved handling for instances that use database snapshots.
- Ability to do intra-day differential backups purely by setting maintenance times and limits in the policy table.
The code posted here is cumulative, and replaces entirely the original code, but please refer back to that original blog post for description, instructions and details. This update can be installed right over an existing deployment, or be installed all by itself as a complete solution but – as always – please test and be cautious.
Note: I've posted updates to this solution. Please get the latest version here.