473,320 Members | 1,951 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Installing SQLServer 2000 service packs on Clustered server

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

Aug 30 '05 #1
3 1897
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

Aug 30 '05 #2
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


Aug 31 '05 #3

<ly*******@gmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.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:
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

Aug 31 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Daniel Kim | last post by:
Hello! When trying to install SqlServer 2000 Developer (as Administrator) on my Windows XP Professional I get the following message at the point where the system asks Local Account or Domain...
3
by: Senthuran | last post by:
Hi, The SQL server 2000 Server hangs some times. It is not periodic. It is not specific in any queries, which are taking more time to execute. Because, it is occurring for different types of...
12
by: Puvendran | last post by:
Hi, We have encountered deadlock on a table which is used to generate sequential numbers for different categories eg typical entries Category Value TRADE_NO ...
5
by: Raj | last post by:
Hi, I'm a newbie with SQL Server 2000 Developer. I know that it is supposed to install on Windows XP Pro, but I keep running into the following message: "The logon account cannot be validated...
7
by: Bart Torbert | last post by:
Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the...
0
by: Chris Halcrow | last post by:
Hi I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP. I continually get the error 'cannot configure server' just at the end of the installation. I've tried the following: ...
0
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
1
by: Trevor Best | last post by:
SQLServer 2000, after installing SP4 I get a lot of stop errors as noted in the subject. KB suggests hardware failure but so far I haven't found any faulty componants. The errors started happening...
0
by: Leko | last post by:
I am installing SQL server 2000 on windows 2003 and getting an error of SQL_Latin1_General_CP1_CI_AS -m -q -T4022-T3659 An error occured when trying to start this service (1053) I am...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.