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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Correct. Service packs are applied per instance. Having Virtual SQL
Instances at different service pack levels does not affect node hosting
ability.

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


"JamesW" <JamesW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DA027E72-1C27-40BC-B27F-E8BBA975291B@xxxxxxxxxxxxxxxx
So as long as I specified that my passive node could own both instances it
should be able to run both virtual servers since the service packs are
applied to the virtual server not to the node, correct?

"Geoff N. Hiten" wrote:

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