Post reply

Two SQL Instances in one cluster group

  • July 18, 2007 at 9:05 am

    #117780

    I want to know, if setting up  two SQL Instances running under one cluster group is feasible.

    The factors that have to be taken into considerations for this setup.

     

    Thanks.

  • July 19, 2007 at 12:15 am

    #720617

    Not sure when you say one cluster group.

    But however if its a 2 node Cluster then you may think of having 2 instances in Active-Active or Active-Passive.

    Each of the SQL Instances will have a SQL Virtual IP Address and unique SQL Virtual Name and would be assigned to different groups. Each of this SQL Virtual Instances will have it own disk resources and they will not be shared.

    It is better to have one Virtual SQL Server to be active on 1 node and other to be active on another node thereby sharing proper resources.

    Thanks

    Sumit

  • July 19, 2007 at 2:28 am

    #720640

    Yes two instances of SQL Server in one cluster group is possible.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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