FYI: SQL 2005 SP2 Problem!!!!

[Catadmin]

All,

I have just been notified about the following problem with SQL Server 2005 Service Pack 2.

A serious issue has been reported against SP2 concerning database maintenance plans.

We are mainly concerned because the problem happens silently and customers may not be aware that their maintenance deletion policies have changed. Worst case this could mean that some customers are running without backups because their deletion policy changed.

We plan on posting a message on the download site tonight warning customers about this issue. Also, we have notified our marketing team who will help send out an all-points-bulletin to the field plus are engaging our community team to help us message this externally.

In the mean time, customers who notice that their plan changed can correct their plan using the SP2 tools. Therefore we are going to communicate this widely but at the moment are not recalling SP2.

Hope this helps someone out. I don't think it affects plans created by programs like Litespeed Backup, but I'll post again if I notice that it does.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[SQLBill]

I have heard that the issue is that SP2 changes the time that backup files are kept to one hour.

-SQLBill

Posting advice: FAQ481-4875