THE SQL Server Blog Spot on the Web

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

Merrill Aldrich

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.

Enjoy!

Note: I've posted updates to this solution. Please get the latest version here.

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

Attachment(s): RulesMaintenanceV1_2.zip

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

Comments

 

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

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement