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

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

  • Re: Single node cluster with multiple instances but all as default
    ... Thanks Geoff. ... "true" cluster, or stick with the two part naming. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help Setting up SQL 2005 in a Windows 2008 Cluster in a multi
    ... Ok Geoff, I got you; there are no support documents out right now. ... List of known issues when you install SQL Server 2005 on Windows Server 2008 ... Principal SQL Infrastructure Consultant ... Actually we have an Exchange 2007 CCR Cluster setup the same way I want ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Cluster Hardware Compatibility Requirements
    ... I agree with Geoff here on this. ... SQL servers are generally constrained on memory, CPU, or IO ... Along with switching server venders ...
    (microsoft.public.sqlserver.clustering)
  • Re: ActiveActivepassive setup
    ... "Geoff N. Hiten" wrote: ... Principal SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... but SQL clustering is "shared nothing". ...
    (microsoft.public.sqlserver.clustering)
  • Nevermind: Problem Between the Chair and the Keyboard
    ... Thank you, Geoff! ... ill-acquainted with SQL and a data table seems to LOSE all of its records! ... > I support the Professional Association for SQL Server ... >> The indication that the records were DELETED is that Server Enterprise ...
    (microsoft.public.sqlserver.server)