sql2005 able to run in a cluster?

Posted on 2006-05-17
Last Modified: 2013-11-15
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 ...

Question by:kacalapy
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    LVL 28

    Expert Comment

    ok i implemented sql 2005 enterprise edition successfully on clusters.

    but i used named instanse for sql 2005.
    LVL 1

    Author Comment

    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.
    LVL 142

    Accepted Solution

    >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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now