Re: SQL Server and Hotfixes

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/31/04


Date: Wed, 31 Mar 2004 11:39:29 -0500

At one time or another I have installed numerous hotfixes. Right now, the
only one I would recommend is the security rollup in build 818. Hotfixes
are designed to fix specific issues and don't undergo as rigorous testing as
the full service packs. Unless you need to, don't apply hotfixes.

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Justin Hoffmann" <hoffmann-j@blankrome.com> wrote in message
news:4DB9638B-239F-4D8A-8F6B-D0169F9B3CE0@microsoft.com...
> I am curious to see what others would recommend or have installed on their
SQL Server 2000 machines.  Has anyone applied the hotfixes released since
SP3a?  If I wanted to create the most up to date SQL Server, would I do the
following?
>
> 1. Install SQL 2000
> 2. SP3a
> 3. MS03-031 (815495)
> 4. MDAC 2.8
> 5. MS04-003 (832483)
>
> Also, let me know if I missed anything.
>
> Thanks,
>
> Justin Hoffmann


Relevant Pages

  • Re: upgrading cluster hardware
    ... The install process puts RTM binaries on the new node. ... be updated with any service packs or hotfixes you ran. ... Microsoft SQL Server MVP ... > Do I have to install the service pack again? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cannot update
    ... > SharePoint Services on SBS 2003 is called Microsoft SQL Server ... > We recommend you install SQL SP4, it include a lot of new hotfix for SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: latest hotfixes and SP3
    ... supposed to install SP3a. ... Search Page for SQL Server 2000 hotfixes (checked: ... Release A (This release includes the fixes for the Slammer (W32.slammer) ...
    (microsoft.public.sqlserver.server)
  • Re: latest hotfixes and SP3
    ... Don't install all of them that I can tell you. ... from widows update service. ... > Can anyone tell me what additional hotfixes for SQL do I have to install ... Search Page for SQL Server 2000 hotfixes (checked: ...
    (microsoft.public.sqlserver.server)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)