March 18, 2014 at 6:50 am
Hi,
We need to install a New sql instance an existing Prod cluster node.We have 4 node cluster and 2 sql instance are running on it.
Node 1---instance A running
Node 2---Instance B running
Node 3 and Node 4 is free.
Win 2008 r2
SQL server 2008 r2 with sp2
Can any one give me the step by step implementation plan for that and what will the estimation for completing sql instance on all nodes.?
Thanks in advance.
March 18, 2014 at 7:18 am
Install a "new failover SQL cluster installation" on a node. Although it should not matter I prefer to install on a non-used node (node 3 or node 4), just in case you run into issues. Subsequently install a "add node to a SQL failover cluster" on all other nodes (that you want to use).
Preferably use a slip-streamed installation of SQL and SP2. Then you don't need to install SP2 seperately.
In some cases the SQL GUI installation could take a lot of time to get through all windows. Therefor I prefer to use unattended installations. But when the installation fails it takes a bit more time to troubleshoot, because you don't know at which point it failed. In case of failure using the GUI mostly gives you a starting point to troubleshoot.
It would take approx. 2 or 3 hours to install a brand new instance (without additional configuration) on a 4-node cluster.
March 18, 2014 at 7:49 am
Thanks for reply,
" use a slip-streamed installation of SQL and SP2 ?"
Can you tell me how to combine SQL with sp2 ( slip-streamed).?so that it will reduce m time while installing.
March 18, 2014 at 7:59 am
You can find several sites on the internet to get a step-by-step on how to create a slipstream installation set. For example:
http://sqlcurve.wordpress.com/2013/06/04/how-to-slipstream-sp2-or-sp1-for-sql-2008-r2/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply