473,325 Members | 2,712 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,325 software developers and data experts.

Upgrade SQL Server 2000 Failover Cluster from SP3 to SP4

I have a production failover cluster running SQL Server 2000 at SP3
that I want to upgrade to SP4. I do not have a test failover cluster
to test with so I need the install on the primary server to work the
first time. Per the information I have I just install the patch on the
primary server and it will install both on the primary and on the
secondary.

However, I remember when I did the initial install and it failed. The
first problem traced to the fact that the install uses temporary files
under the profile of the installing administrator and the id had never
logged into the second server so the install failed on creating the
temporary file. The was a second problem that related to an OS feature
that had to be off for the install to work.

If anyone out there has done this upgrade and remembers encountering a
problem and its fix/workaround I would appreciate a head up warning.

Thank you
-- Mark D Powell --

Sep 6 '06 #1
1 2409

Mark D Powell wrote:
I have a production failover cluster running SQL Server 2000 at SP3
that I want to upgrade to SP4. I do not have a test failover cluster
to test with so I need the install on the primary server to work the
first time. Per the information I have I just install the patch on the
primary server and it will install both on the primary and on the
secondary.

However, I remember when I did the initial install and it failed. The
first problem traced to the fact that the install uses temporary files
under the profile of the installing administrator and the id had never
logged into the second server so the install failed on creating the
temporary file. The was a second problem that related to an OS feature
that had to be off for the install to work.

If anyone out there has done this upgrade and remembers encountering a
problem and its fix/workaround I would appreciate a head up warning.

Thank you
-- Mark D Powell --
Followup. The SP4 patch installed without a hitch though unlike on the
prior Standard editon upgrades I did where you were shown screens that
stated what was being done: update MDAC etc..., all that came up was a
blue screen with a message about checking on the cluster and this might
take a while. After a 'while' the message changed to something about
creating cluster resources then the finished screen appeared saying it
was time to reboot.

-- Mark D Powell --

Sep 13 '06 #2

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

Similar topics

0
by: Fredrik Möller | last post by:
Hi all, I need help in solving a connection problem. There is a failover cluster running SQL Server 2000 in to instances, 'AUTUMN-03' and 'WINTER-03\I1'. On an other machine I run a service,...
0
by: jwbeaty | last post by:
Is there a method to determine if a cluster has failed over via data stored in SQL Server? I'm looking for a method to determine if a failover has occurred by running a script of some sort (i.e....
4
by: Chris Gatto | last post by:
Hello, My organization is currently considering the purchase of a new intranet application server and we are looking for opinions from those who have been down this road before. In brief the...
1
by: news.microsoft.com | last post by:
Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State...
5
by: uspensky | last post by:
We are trying to setup a system to system failover cluster using two nodes (x346) which each have a single hba running to seperate controllers on the DS400. For full redundnancy, IBM recommends...
2
by: Jay Balapa | last post by:
Hello, We have two Windows 2003 servers one running IIS and another for SQL Server. We are at a stage where we need to load balance and provide a failover. Can you show us a technical...
4
by: Ronald Green | last post by:
Hi, I have this theoretical problem: Say that I need a chat server that also has a database where it saves all conversations. However, I need several servers for availability and load balancing....
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
1
by: snomad | last post by:
Hi all, I had a node failure and rebuild on a sql server 2005 2 node cluster. the server has been rebuilt with new os. i evicted then re-added the rebuilt node via cluster administrator. i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.