You are here: Re: Upgrade SQL Server 2000 Failover Cluster from SP3 to SP4 « MsSQL Server « IT news, forums, messages
Re: Upgrade SQL Server 2000 Failover Cluster from SP3 to SP4

Posted by Mark D Powell on 09/13/06 15:24

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 --

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация