Add additional SQL instance to existing SQL Server 2012/2014 Cluster

  • HI

    I just created SQL Server 2012 active/passive two node cluster. Have F:\ Data G:\ Log for this cluster

    Now I want to add sql 2014 with names instance to this cluster .

    Can I use same shared F:\ and G:\ Drive to store files?

    -- I tried to use same shared drive with new failover cluster option but during insta llation define path for data directoy said path not belong to cluster resrource..

    When start installation first screen which option should choose?

    -- Install stand-alone..... or new sql server failover cluster installation

    Any other useful infor?

    Thank you again

  • Since you have shared storage, you cannot us the same shared storage for the 2014 cluster install whether you are doing AlwaysOn or Traditional clustering. You will need to get two more drives for the data and logs for the new instance and choose new cluster install

    MCSE SQL Server 2012\2014\2016

  • logicinside22 (7/12/2014)


    HI

    I just created SQL Server 2012 active/passive two node cluster. Have F:\ Data G:\ Log for this cluster

    Now I want to add sql 2014 with names instance to this cluster .

    Can I use same shared F:\ and G:\ Drive to store files?

    Hi,

    Two different clustered instances cannot share any of their resources. When installing new Failover Cluster instance it'll require it's own disks, network name and IP address, just like the first instance you installed, did. The installation itself is also pretty much the same for the second instance than it was for the first, so choose New SQL Server Failover Cluster installation.

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

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

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