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 2012 instance to Windows Failover Cluster Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 2:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 18, 2014 12:00 PM
Points: 8, Visits: 31
Hi All,

I have a Windows Failover Cluster setup across 3 nodes with only 1 service/application running on it - which is SQL Server 2012. Everything works great, however now I need to add another SQL instance for an entirely different project. I have added an additional iSCSI volume to the failover cluster and it shows up just fine. At this point, how to I add an additional instance of SQL 2012 to this cluster using the new storage disk?

I assume I'd just pop the SQL Server 2012 disc in one of the nodes and install a new SQL Server Cluster instance and then go around to the rest of the nodes and just use the 'add node' option, but I just wanted to verify first. I attempted to do this and got cold feet when it came to the part about installing the setup and support files. The reason I got cold feet was because we have a group of people using the existing SQL 2012 instance and I didn't want to disrupt anything.

Can anybody please provide any instructions or steps for adding a new instance to my failover cluster?

Thank you all!
Post #1497035
Posted Friday, September 27, 2013 7:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:25 PM
Points: 6,194, Visits: 13,350
dgraf (9/20/2013)
Hi All,

I have a Windows Failover Cluster setup across 3 nodes with only 1 service/application running on it - which is SQL Server 2012. Everything works great, however now I need to add another SQL instance for an entirely different project. I have added an additional iSCSI volume to the failover cluster and it shows up just fine. At this point, how to I add an additional instance of SQL 2012 to this cluster using the new storage disk?

one volume is ok, but you may want to consider more volumes for separating log files, backup files, etc


dgraf (9/20/2013)
I assume I'd just pop the SQL Server 2012 disc in one of the nodes and install a new SQL Server Cluster instance and then go around to the rest of the nodes and just use the 'add node' option, but I just wanted to verify first. I attempted to do this and got cold feet when it came to the part about installing the setup and support files. The reason I got cold feet was because we have a group of people using the existing SQL 2012 instance and I didn't want to disrupt anything.

Can anybody please provide any instructions or steps for adding a new instance to my failover cluster?

Thank you all!

Once you have the storage fromatted and presented to all the participating cluster nodes, just select to install a new failover cluster instance, then run add node on any other nodes you wish to participate in the clustered instance. It will not take the running instance offline


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1499371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse