Thank you for the heads up on this Anwar!
Pete
Peter M. Florenzano
Database Administrator
Distributed Computing
Email: Peter.[Email address protected]
Phone: (203)752-4317
"Anwar Sonday "
<mssqldba-ezmlmsh
ield-x1671702.x11 To
[Email Address Removed] "LazyDBA Discussion"
com> <[Email address protected]
cc
02/27/2007 07:20
AM 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
CONFIDENTIALITY NOTICE: This message and any attachments may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee or addressees named above for its intended purpose. If you are not the intended recipient of this message, this message constitutes notice that any review, retransmission, distribution, copying or other use or taking any action in reliance on the information in this message and its attachments, is prohibited. If you receive this communication in error, please immediately advise the sender by reply e-mail and delete this message and its attachments from your system without keeping a copy. Unless expressly stated in this e-mail, nothing in this message may be construed as a digital or electronic signature. Thank you.
MS Sql Server LazyDBA home page