| Author |
Installing SQLServer 2000 service packs on Clustered server
|
|
| lyn.duong@gmail.com 2005-08-30, 3:25 am |
| Hi,
I am planning to install sql server 2000 sp4 on my clustered server
running in active/passive mode.
I plan to stop all sql services using cluster administrator, install
the service pack from the primary node and then reboot all nodes.
Are there any missing steps that need to be done or problems that
anyone has come across?
Thank
Lyn
| |
| Simon Hayes 2005-08-30, 7:24 am |
| The SP4 readme has a section about installing on a cluster. There are
also some updates to the readme which relate to clustered systems, so
you should probably review the latest details:
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
Simon
| |
| lyn.duong@gmail.com 2005-08-31, 3:24 am |
| Any advice for a backout in case the installation goes wrong ?
Simon Hayes wrote:
> The SP4 readme has a section about installing on a cluster. There are
> also some updates to the readme which relate to clustered systems, so
> you should probably review the latest details:
>
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx
>
> Simon
| |
| Greg D. Moore \(Strider\) 2005-08-31, 7:24 am |
|
<lyn.duong@gmail.com> wrote in message
news:1125459865.003676.42760@g49g2000cwa.googlegroups.com...
> Any advice for a backout in case the installation goes wrong ?
I tend to keep airline tickets to a small country without extradition
treaties and my passport handy. :-)
Seriously -
The article should outline it but basically, backup your system databases
and be prepared to reinstall SQL Server and restore your backups.
(Generally the user databases are unaffacted.)
Note too though if you don't already have SP3 installed, your full-text
indexes will be invalidated, so you may want to read up on backing them up
and restoring them also.
>
>
> Simon Hayes wrote:
>
|
|
|
|