BT

SQL Server 2005 SP 2 Upgrade Warning

by Jonathan Allen on Mar 02, 2007 |

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.

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.

Tell us what you think

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

Email me replies to any of my messages in this thread
Community comments

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

Email me replies to any of my messages in this thread

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

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT