Hi Anwar,

It is documented on the download page with a link to this:

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

Regards
Rodney


-----Original Message-----
From: Anwar Sonday
[mailto:mssqldba-ezmlmshield-x1671702.[Email address protected]
Sent: 27 February 2007 02:21 PM
To: LazyDBA Discussion
Subject: RE: SP2 for SQL2005


Please be aware of the following:

************************************************************************
*************************************************
Please be aware that we just discovered a serious problem concerning
database maintenance plans in SP2.
If you have a sql server 2005 maintenance plan that includes a history
cleanup task or a maintenance cleanup task, then, after sp2 is
installed, files will be deleted more frequently than the user specified
when he created the plan. This could lead to a situation where a backup
was deleted before the next backup was invoked.

We are working on a GDR (mandatory QFE) that will be available within
days to fix this bug

In the meantime, if you use database maintenance plans you should check
your deletion policies to ensure your backups are not accidentally
getting deleted before the next backup occurs. You can fix this
manually.

If you don't use DB maintenance plans, you are not impacted by this
issue.
************************************************************************
***************************************************


-----Original Message-----
From: Norkett Margaret
[mailto:mssqldba-ezmlmshield-x84883329.[Email address protected]
Sent: Friday, February 23, 2007 11:17 PM
To: LazyDBA Discussion
Subject: SP2 for SQL2005

Have any of you installed this yet? Any problems/glitches/catches?



Thanks!



If you have any questions or concerns, please let me know them.



Margaret Norkett

Database Administrator

* 864-271-6522 ext 222

* 864-270-2884











---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Disclaimer
http://www.shoprite.co.za/disclaimer.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page