Post reply

Prerequisites for additional SQL Instance on existing cluster

  • September 4, 2015 at 9:40 am

    #320999

    Hi DBAs,

    We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.

    Now we need to install another SQL instance on this cluster. So what are the prerequisites apart from new IP address? Do we need shared disks or can the existing disks can be utilized?

    I haven't performed this before and so have confusion about prerequisites; please bear with me.

  • September 4, 2015 at 11:14 am

    #1824748

    SUBRAHMANYA HEDGE (9/4/2015)

    Hi DBAs,

    We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.

    Now we need to install another SQL instance on this cluster. So what are the prerequisites apart from new IP address? Do we need shared disks or can the existing disks can be utilized?

    I haven't performed this before and so have confusion about prerequisites; please bear with me.

    Here's forum post on this topic:

    http://www.sqlservercentral.com/Forums/Topic925110-391-1.aspx

    Basically each cluster group has it's exclusive resources.

    If you look at the existing cluster group you'll need the same resources separately (i.e. IP, name, disk etc). It used to need it's own MSDTC I think.

    I vaguely remember cluster shared disks when I migrated from windows 2003 MSCS to 2008 R2 many years ago... if it's not already a shared disk you'll need to use different ones.. I think there was limitations on shared disks but not sure... my view was each cluster group should have their own resources.

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

  • September 4, 2015 at 11:42 am

    #1824751

    @mike-2 - Thanks !!!

    We just ran the setup rules and found that indeed "Cluster Shared Disk Available Check" has failed. So I am sure we need:

    - a separate IP

    - separate shared drives to host database files

    What I am not sure is, if we require separate MSDTC also.

  • September 4, 2015 at 2:04 pm

    #1824776

    If I remember correctly with 2008 R2 you don't need separate msdtc... I'm 99% sure that you only need 1...

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

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

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