THE SQL Server Blog Spot on the Web

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

Tibor Karaszi

Review your Maint Plans after sp2!

You might have heard that Maint Plans has had some work on them in sp2. One enhancement is that the Maintenance Cleanup Task now allow for removing of backup files based on hours. This can lead to undesired too early cleanup if you upgraded such a plan. I haven't tested this, I just learned it from the open newsgroups, but my guess is that perhaps the smallest earlier interval (days) is not treated as the smallest interval (hours).

Whether or not that is an accurate description from a technical viewpoint, the end result is that your cleanup can be done earlier than expected.

 The fix is simple: open the cleanup task, adjust the value and save it again.

Published Sunday, February 25, 2007 11:03 AM by TiborKaraszi
Filed under:

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

No Comments

Leave a Comment

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