Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add additional SQL instance to existing SQL Server 2012/2014 Cluster Expand / Collapse
Author
Message
Posted Saturday, July 12, 2014 3:18 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:03 PM
Points: 321, Visits: 1,287
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


Aim to inspire rather than to teach.
SQL Server DBA
Post #1591956
Posted Monday, July 14, 2014 9:01 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:25 AM
Points: 301, Visits: 595
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

MCSA SQL Server 2012
Post #1592216
Posted Tuesday, July 15, 2014 1:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 12:33 PM
Points: 38, Visits: 561
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
Post #1592426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse