Re: 3 node cluster with two SQL instances. Mixed SQL service pack?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Russ is correct.

Please note that all shared resources (tools, MDAC, etc.) will be at the
highest service pack level regardless of install or update order.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Russ Kaufmann [MVP]" <russ@xxxxxxxxxxxxxxx> wrote in message
news:OjPNY74bGHA.3824@xxxxxxxxxxxxxxxxxxxxxxx
"JamesW" <JamesW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C478186-3F66-4E1E-98C0-997C66D27663@xxxxxxxxxxxxxxxx
We have a 2 node active/passive cluster running SQL2K SP4. I want to add
another node and make it Active/Active/Passive with the one active node
running the default SQL instance and the other Active running a named
instance with the passive node taking over for both instances in a
failover
scenario. One of the instances needs to be SP3a(vendor requirement) and
the
other SP4. Is this possible? Or would it make more sense to create
another
active/passive cluster and buy two new servers?

You can have multiple instances in a cluster at different service pack
levels.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp




.

Relevant Pages

  • Re: Attachment trouble
    ... If the words Service Pack 2 is present at the end of the line, then you have Windows XP SP2 installed. ... The System tab should display the Operating System, and the Service Pack level of your installation. ... I can see attach in bottom half of email but when I ...
    (microsoft.public.windowsxp.general)
  • Re: read o.s. and Office version
    ... GetOsVersionNumber (and GetSPNumber for service pack level) here: ... With WMI ... If you need to know in more detail what Office version it is (service pack ... -- torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway Administration scripting examples and an ONLINE version of the 1328 page Scripting Guide: ...
    (microsoft.public.scripting.vbscript)
  • Re: SP3
    ... Anything after this will be a rollup of updates for convenience of new users but will not increase the service pack level. ... Service pack level three will be the level supported until the end of extended support in 2014 since there will not be a newer service pack level to supercede it. ...
    (microsoft.public.windowsxp.general)
  • Re: SP3
    ... Anything after this will be a rollup of updates for convenience of new users but will not increase the service pack level. ... All updates after SP3 will simply be updates to XP service pack level three. ... Service pack level three will be the level supported until the end of extended support in 2014 since there will not be a newer service pack level to supercede it. ...
    (microsoft.public.windowsxp.general)
  • Re: Any word on when XP SP3 Beta will start?
    ... You can use the SPCheck to determine the service pack level of installed ... SPCheck is included with the Windows XP Support Tools package. ...
    (microsoft.public.windowsxp.general)