[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

sql2005 able to run in a cluster?

im having trouble finding info on whether or not sql 2005 standard edition is able to run in a database cluster environment.

can anyone point me to the answer?

I am deciding if I need sql2005 enterprise edition, or I can use standard ...

  • 2
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
ok i implemented sql 2005 enterprise edition successfully on clusters.

but i used named instanse for sql 2005.
kacalapyAuthor Commented:
angelIII ,

can i use 2+ servers with sql2005 std edition?
or would i need ent. edition for all 3+ servers?

i have 2 sql boxes now but may need to add more soon.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>i have 2 sql boxes now but may need to add more soon.
This depends on how many instances you cluster around.

Say, you cluster 1 insteance onto each time 2 nodes, you need to install the std edition on Node B 2 times, and once on A and C
NODE A   instance 1
NODE B   instance 1   , instance 2
NODE C                    , instance 2

if you want the same instance to be on 3+ servers, you need Ent. edition.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now