THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Merrill Aldrich

Technical content about Microsoft data technologies. All opinions expressed are purely my own and do not reflect positions of my employer or associates.

March Update to Rules-Driven Maintenance

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:

  1. Much improved handling for instances that use database snapshots.
  2. 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.

Published Monday, March 11, 2013 8:56 PM by merrillaldrich


Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Merrill Aldrich : Rules-Driven Maintenance said:

March 11, 2013 11:05 PM

Merrill Aldrich said:

Tomorrow I’m making the beautiful drive down from Minneapolis into Iowa to present to the I-180 / East

March 11, 2013 11:13 PM

Merrill Aldrich said:

I have been working on new features for the Rules-Driven Maintenance Solution , including per-index maintenance

September 18, 2013 6:19 PM

silk said:^Eescort.html^Eescort.html^Eescort.html^Eescort.html

February 9, 2019 8:12 AM

Leave a Comment


This Blog


Privacy Statement