Installing an sql server 2008 cluster on server 2008 from scratch

Discussion in 'microsoft.public.sqlserver.clustering' started by martin, Nov 22, 2008.

  1. martin

    martin Guest

    Hi,

    On the installation screen we have two options

    1. New SQL SERVER failover cluster installation.
    Launch a wizard to install a single-node SQL SERVER 2008
    failover cluster.
    2. Add node to a SQL SERVER failover cluster.
    Launch a wizard to add a node to an existing SQL SERVER
    failover cluster.

    However, if we choose "Advanced" from the SQL SERVER 2008 Installation
    screen we get two new options for clustering

    1. Advanced Cluster Preparation
    Launch a wizard to prepare a SQL SERVER 2008 failover cluster
    installation.

    2. Advanced Cluster Completion.
    Launch a wizard to complete a SQL SERVER 2008 failover cluster from
    a list of cluster-prepared SQL SERVER 2008 instances..


    my question is which is the best way to go?

    The option I chose was on the first node "Advanced Cluster Preparation" and
    then "Advanced Cluster Completion" and then on the second node "Add node to
    a SQL SERVER failover cluster"

    all seems ok, however could I have made a better choice?

    also, the option that lets me "Launch a wizard to install a single-node SQL
    SERVER 2008 failover cluster." leads me to the additional question

    is it possible / sensible to have a single-node sql server 2008
    installation, or is this just a starting point for something bigger?

    many thanks in advance for your answers / comments.

    cheers

    martin.
     
    martin, Nov 22, 2008
    #1
    1. Advertisements

  2. martin

    Ross Mistry Guest

    There isn’t a right or wrong way of doing things. Basically it is a
    preference thing as both utilities provide you with the same end result.
    However, when using the Advanced Cluster Preparation settings are
    preconfigured ahead of time, therefore, time may be saved when implementing
    many nodes within a cluster or if you need to implement many clusters.

    From what I have seen most individuals use the "Launch a wizard to install a
    single-node SQL SERVER 2008 failover cluster" on the first node and then
    "Launch a wizard to add a node to an existing SQL SERVER failover cluster" on
    subsequent nodes. Most times they use this methodology as it is similar to
    previous installation methods and there is a false perception that the
    advanced methodology is too complex - which it is not.

    I hope this helps

    Thanks Ross
     
    Ross Mistry, Nov 22, 2008
    #2
    1. Advertisements

  3. Just to clarify, The advanced clustering options are primarily there to
    support sysprep scenarios. The wizard is the best way to deal with one-off
    clusters.
     
    Geoff N. Hiten, Nov 24, 2008
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.