Facilitating the spread of knowledge and innovation in professional software development



Choose your language

InfoQ Homepage News SQL Server 2005 SP 2 Upgrade Warning

SQL Server 2005 SP 2 Upgrade Warning


According to the SQL Server Manageability Team, there is a bug in the maintenance plan engine that may cause it to delete historical information too soon.
Service Pack 2 includes the ability delete old data using the History Cleanup Task and Maintenance Cleanup Task. These tasks have been changed to allow deleting entries whose age is measured in hours in addition to the days, weeks, months, and years previously supported. Unfortunately a bug in the service pack may cause the time span to be misinterpreted.

No fix is being offered at this time, but the workaround is to simply open each maintenance task and manually reset the interval.

We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.