468,284 Members | 1,504 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

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 2221

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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Chris Gatto | last post: by
1 post views Thread by news.microsoft.com | last post: by
2 posts views Thread by Jay Balapa | last post: by
4 posts views Thread by Ronald Green | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.