sql 2005 Clustering

  • i will be setting up SQL Clustering.

    http://www.mssqltips.com/tip.asp?tip=1648

    The following thread:

    (For windows clustering active/passive)....Two nodes A and B

    When selecting Cluster Group Name - i assume this cannot be the name of the Actual ServerName but has to be something difference.

    The link above - gives DC Cluster Name

    SQL01 -- This is the name of the sql server and not the SQL Server Instance name that is used when connecting to the SQL itself.

    What is your naming conventions used?

  • We use simple names for the actual server names:

    SQL01

    SQL02

    And a descriptive name for the cluster group:

    SQLCLUST

    With a "v" to visually distinguish the virtual names:

    VSQL01

    VSQL02

  • Inside of your cluster administration you see

    SQLCLUST

    Cluster Group

    MSTDC

    VSQL01

    VSQL02

    Then

    SQL01

    Active Groups

    SQL02

    Active Group

    So users connecting to SQL Instance is VSQ01

    Cheers

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply