Re: How to install service pack 3a on a failover cluster

From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 15:18:25 -0600

Ok, you are passed my SQL knowledge; Geoff or Uttam a little help please :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"pepe" <pepe@discussions.microsoft.com> wrote in message
news:5C72F96D-938F-4321-ABE4-BD098CE363B9@microsoft.com...
> Let me backtrack a little. When I said that the install went well, I
> should
> have said that the unpacking of the install files went well :) I know,
> dumb...
>
> Anyway, when I actually did try the service pack install it asked me to
> supply the name of the virtual server but it would not take the name. Our
> server virtual name is ncm-sql. We have two instances of sql running so I
> tried the names of one of the sql instances, in this case it was sqlncm
> and
> it accepted it. I was wondering why.
>
> I believe the answer is that the instructions mean "virtual sql server"
> not
> virtual cluster server" even though they say "virtual server".
>
> The rest of the install went fine and then I moved the two cluster groups
> to
> the second node and rebooted the first node. At this time several of the
> sql
> cluster resources started to fail. Of course, I panicked. But I just
> waited
> for the first node to come back up and then I moved the groups back to the
> first node and now they are working find.
>
> However, when I search for the ssnetlib.dll file to check the version, the
> folder that reflects the instance that I used to apply the service pack
> shows
> version 2000.80.766.0 which implies sp3a. But the version for the instance
> that I didn't upgrade still shows 2000.80.534.0. I am guessing that I need
> to
> re-apply the service pack but when it asks for the virtual server name, I
> should use the name of the second instance?
>
> pepe
>
>
> "Rodney R. Fournier [MVP]" wrote:
>
>> So, the install completed and asked you to reboot the Active node right?
>>
>> Cheers,
>>
>> Rod
>>
>> MVP - Windows Server - Clustering
>> http://www.nw-america.com - Clustering
>> http://www.msmvps.com/clustering - Blog
>>
>> "pepe" <pepe@discussions.microsoft.com> wrote in message
>> news:F6993B99-3C24-43EB-ABE2-567967B03F1C@microsoft.com...
>> >I think I spoke too soon.
>> >
>> > I checked the sql version in query analyzer and it says
>> > Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001
>> > 13:23:50
>> > Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on
>> > Windows
>> > NT 5.0 (Build 2195: Service Pack 4)
>> >
>> > I'm guessing that this service pack didn't get applied properly. Any
>> > thoughts on what I could do next?
>> >
>> > Thanks,
>> > pepe
>> > "pepe" wrote:
>> >
>> >> Thanks to both of you. The document that you referred me to Uttam was
>> >> one
>> >> I
>> >> found several months ago but didn't find it online again. I did find a
>> >> paper
>> >> copy i had printed. Rodneys "English" interpretation was just what I
>> >> needed
>> >> to confirm what I was going to do was what I should be doin.
>> >>
>> >> So far, so good. Service Pack install went well.
>> >> Thanks again for your time.
>> >> pepe
>>
>>
>>

Relevant Pages

  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Choosing correct high availability setup
    ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
    (microsoft.public.sqlserver.clustering)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)