Re: patching

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 03/09/05


Date: Wed, 9 Mar 2005 20:50:34 +0100

Hi

A SP is a fully end to end tested release that implements fixes and
enhancements to the base product. SP's are cumulative (then contain all
prior SP's fixes plus more).

A Security patch is a hotfix that addresses high priority fixes that if not
applied, could lead to compromised security.

A Hotfix is an update, issued to fix a specific problem that somebody had
encountered and Microsoft needs to fix as it could affect other users. A
Hotfix has limited support and does not have the massive amount of
regression testing as a Service Pack would as it is not possible in the
short time frames needed.

NEVER get a hotfix/SP/Security pack from any other source than Microsoft.
Microsoft never e-mails files either. There is always a link to their site
from where you can download it. You never know who has tampered with the
files if you don't get them yourself from MS.

With any release, always put it on test servers before production ones.
Functionality can change or behavior you were used to could be altered in a
way that your applications were not expecting.

www.microsoft.com/sql
www.microsoft.com/security

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Rich" <Rich@discussions.microsoft.com> wrote in message
news:FECD7708-9C36-4810-9EF8-D011ADB6B021@microsoft.com...
> What is the differnce between a Service Pack and Security Patches that
come
> out over time? What about Hot Fixes? Is Microsoft the only sources of
> patches? Should I test the patch on a demo server before I place it in
> production or should I just trust Microsoft?



Relevant Pages

  • Re: patching
    ... Always test service packs before putting them into production. ... >> A Hotfix is an update, issued to fix a specific problem that somebody had ... >> NEVER get a hotfix/SP/Security pack from any other source than Microsoft. ...
    (microsoft.public.sqlserver.security)
  • Re: patching
    ... > prior SP's fixes plus more). ... > encountered and Microsoft needs to fix as it could affect other users. ... > regression testing as a Service Pack would as it is not possible in the ... always put it on test servers before production ones. ...
    (microsoft.public.sqlserver.security)
  • Re: Event ID 5504
    ... > Should I be phoning Microsoft and applying the hot fix? ... queries are being sent to the ISP's DNS that are being rejected. ... I'm not sure what the hotfix your speaking of fixes, ...
    (microsoft.public.win2000.dns)
  • Re: Event ID 5504
    ... > Should I be phoning Microsoft and applying the hot fix? ... queries are being sent to the ISP's DNS that are being rejected. ... I'm not sure what the hotfix your speaking of fixes, ...
    (microsoft.public.windows.server.dns)
  • KB835732 update and VPC6
    ... restarting the Mac as another user suggested. ... Microsoft, any fixes for your hotfix? ...
    (microsoft.public.mac.virtualpc)