01 March 2007

SQL Server 2005 SP2 – Someone bogged up big time

Thought I better post this incase you havn’t seen it –

If you are using SQL Server 2005 maintainance tasks and upgrade to sp2 be ready for a nasty suprise. If you have a Maintenance cleanup task or a history clean up task your units which used to be measured in days are now measured in hours..

See: http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx for more information..

– James

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

This post has been viewed 1164 times – thanks for reading.

  • Rate
    [Total: 0    Average: 0/5]
  • Share

James Moore runs the SQL Tools division at Red Gate Software.

View all articles by James Moore