| Author |
Topic |
|
gercr
Yak Posting Veteran
53 Posts |
 Posted - 2003-01-29 : 11:13:49
|
| Hi!I want to make a Cluster Active-Active mode, and I want to put 3 instances of SQL (2 on node 1 and 1 on node 2), my question is, witch version of SQL I most to use at the lowest price. The price of list of a standard is like $5000 and enterprise $20000. |
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-29 : 12:24:33
|
| Not only do you need Enterprise Edition, but you need to purchase as many licenses as you have processors. We have two processors on most of our Enterprise Edition SQL Servers, so the cost for us was around 50k per server (and that's just the license). |
 |
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-01-29 : 17:32:35
|
| But is possible than I make a install of Standard ED and work the SQL like a service? or exist a MS restriction about it!? I ask this because actually we have a cluster using SQL 6.5 standard ED and we work the SQL just like a Service than switch node, but is just one instance of SQL and 6.5 version. and at the new cluster we will have 3 instances of SQL and will use SQL 2000.thanks for your help.GGC. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-29 : 17:39:33
|
| I don't understand what you mean by "work the SQL like a service", since SQL Server is a service. |
|
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-01-29 : 19:53:38
|
| I mean than like SQL is a Service, and if I make 3 Instances of SQL Standard ED, I will have 3 distinc services, so I will manage then from the Cluster Administrator, so My question is, is this posible at practice? (making the registry copy (of MSSQL entry) to the other node) Why I need Entreprise ED ???? GGC |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-29 : 20:03:24
|
| You have to use Enterprise Edition because clustering isn't available in Standard Edition. The high availability solution is only available on Enterprise Edition. Software Requirements:SQL Server 2000 failover clustering requires SQL Server 2000 Enterprise Edition and one of the following operating systems: Microsoft Windows NT Server 4.0, Enterprise Edition (with a minimum of Service Pack 5) Microsoft Windows 2000 Advanced Server Microsoft Windows 2000 Datacenter Server If you don't believe me, then see this site: [url]http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/confeat/FAILCLUS.asp[/url]I have no idea what making a registry copy to the other node means either. Copying the registry will not enable you to failover to another SQL Server.Edited by - tduggan on 01/29/2003 20:04:01 |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-01-29 : 20:13:15
|
| If you want it to worrk correctly ( and not fail :) ) get SQL Server 2000 Enterprise. I think that SQl changed what the different editions of SQL Server can do between 6.5 and 2000.Besides, if you have a clustered solution using NON enterprise edition, you are going to run into issues getting database backups to work, etc. Also, if you ever need to call MS for support, they will not support it and/or ask you for the rest of the money you owe them to get enterprise edition :)Just my $0.02.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-01-30 : 11:13:36
|
Thanks to all for your comments.  |
|
|
|
|
Installing Multiple-Instances of SQL on a Cluster