Re: Cluster licensing

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

Oh, my understanding was that with active/active that it is load balancing
the same database on shared storage and if one fails the other just keeps on
trucking. That can't be done?

"Tim Walsh" wrote:

You'd need a license for each server since you would have 2 instances of SQL
running at the same time.

Keep in mind when you say Active/Active you are actually saying you have one
instance of SQL running with it's databases and resources running on Node A
and a second instance of SQL with different databases and resources running
on Node B. In the event of a failure, the instance running on the node that
failed moves over to the other node and now you have 2 instances of SQL
running on the same server. Active/Active doesn't mean you are load
balancing your SQL instances across both servers.

So Active/Passive you have 1 instance running at a time, you need 1 license,
Active/Active you have 2 instances running and therefore you need 2
licenses. If you have a 3rd node running an instance you need a 3rd license.

"Russ Sparks" <RussSparks@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C33484BB-717D-41EC-A647-DC3AAE92FF0A@xxxxxxxxxxxxxxxx
Thank you for your reply. What if I go with active/active clustering?

Russ Sparks


"Jeff Hughes [MSFT]" wrote:

No, since SQL is only active on one node at a time, you only need one
license per instance on a cluster.
--
Jeff Hughes, MCSE
Support Escalation Engineer
Microsoft Enterprise Platforms Support (Server Core/Cluster)


"Russ Sparks" <RussSparks@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9A7A7466-2B44-41F1-8305-D29380152C76@xxxxxxxxxxxxxxxx
This might not be the right place, but, when clustering SQL server
2005,
do I
need to have an additional SQL 2005 enterprise license for the failover
node?




.

Relevant Pages

  • Re: Synchronizing SQL Server CE without replication
    ... You can create SQL CE databases on the desktop, ... nothing to do with the license situation, ... > will require a client license for the desktop and one for the Pocket ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Newbie question
    ... Each instance has an independent set of databases. ... There is currently no native load balancing technology for SQL Server. ... > In a SQL cluster environment, let's say there's 3 nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: database load balancing using sql clustering
    ... With SQL 2000 clustering each instance runs on a single machine, ... Databases are not load balanced in any way. ... MVP - Windows Server - Clustering ... > can sql server 2000 database load balancing be achived by using sql ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)