Re: SQL Server 2005 Service Pack 2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Jun 20, 9:43 am, Riccardone <riccar...@xxxxxxxxx> wrote:
On 20 Giu, 09:27, T_M_P <claudio.to...@xxxxxxxxx> wrote:

Sorry, I forgot to say that I'm speaking about SQL 2005 SP2

:)

The process of applying a service pack is the same.
Cut and paste from official sql server 2005 microsoft documentation

---------------------------------------------
Process of Applying Service Packs and Hotfixes

It is recommended that you always restart a server before applying any
service packs or hotfixes in order to ensure the server starts
properly. This ensures that any preexisting issues with a server are
not attributed to the application of service packs or hotfixes.
As part of your process, you should have an appropriate rollback
strategy if problems are encountered during the update process.

Applying service packs

Service packs are regression tested before release, but you should
still test their impact on the cluster and application solution in a
UAT environment. SQL Server servic packs are cluster aware, which
means they will:
” Detect the failover cluster instance installed during the
configuration of the
cluster.
” Apply the updates and information from the service pack to the
active node.
” Apply the updates and information to the additional nodes.

Before installation of the service pack, it is recommended that you
copy the installation files locally to the active node of the cluster.
The service pack installation process will stop and restart the
relevant services when it completes.

For More Information For more information about how to install a
service pack, see "How to Install Service Packs in a Cluster" on the
Microsoft Help and Support Web site.
---------------------------------------------

regards
Riccardo


Thank you very much
.

Relevant Pages

  • windows 2003 sbs service pack reccomedations???
    ... just wondering about service packs for server 2003 sbs... ... installation guy was probably hesitant of things going wrong and messing the ...
    (microsoft.public.windows.server.sbs)
  • Re: Dreading updating SBS with Service Pack 1
    ... SP1 for SBS contains multiple CDs and/or downloads and thus couldn't be offered like other updates. ... I am really a software developer with no time to manage the server hence why ... If it goes amiss, calls to MS support for issues with Service Packs etc, ... > I thought it would be a walk in the park, just install the Service Pack ...
    (microsoft.public.windows.server.sbs)
  • Re: W2K SP4 Hosed our PC - Need Help !!!
    ... In the server yes I do not like it. ... I told you I did not agree with your assertion that Service Packs of Windows 2000 have come out to fix things that were broke from earlier service packs. ... > SP4, as evidenced in my posts in this thread. ...
    (microsoft.public.win2000.general)
  • Re: Windows SharePoint Service - Fails
    ... Well I would reinstall the server if I knew this would solve my issue, ... service packs on disk. ... Unable to connect to the database STS_Config on ...
    (microsoft.public.windows.server.sbs)
  • Re: IIS still open to hacking even with latest patches...
    ... Unfortunately applying the latest service packs, ... IIS 5.0" which deals with the security issues in configuring IIS ... This doesn't mean that a server configured this way would be 100% ... folder and to the folder just above it (for example the ...
    (microsoft.public.inetserver.iis.security)