April 6, 2010 at 10:50 am
I don’t have a test server for testing Clustering.
I have a second server (instance2) which has all the current SPs and Hot Fixes
I know, that in order to make instance2 a failover server (note: this will be an Active/Passive node), I must install from instance1.
My question is once the install has been completed on instance2, do I need to reinstall the all the current SPs and Hot Fixes again? I presume I will, is this correct?
Thanks,
Ron
April 6, 2010 at 10:55 am
rkinney-802645 (4/6/2010)
I don’t have a test server for testing Clustering.I have a second server (instance2) which has all the current SPs and Hot Fixes
I know, that in order to make instance2 a failover server (note: this will be an Active/Passive node), I must install from instance1.
My question is once the install has been completed on instance2, do I need to reinstall the all the current SPs and Hot Fixes again? I presume I will, is this correct?
If your 2nd instance is on the same server, you cannot setup a cluster. Clustering requires a shared disk (SAN) where u keep ur databases and atleast 2 servers to setup the cluster. The setup file of sql server is cluster aware, so when u install sql server, it is installed on both the nodes. Similarly when u're applying hotfixes in a cluster environment, it gets applied to both (all) nodes simultaneously.
Check BOL to learn more abt clustering..
April 6, 2010 at 11:02 am
I have 2 servers
April 6, 2010 at 11:06 am
rkinney-802645 (4/6/2010)
I have 2 servers
Ok good. Do u have a SAN/NAS setup where u can keep ur databases? If yes, create few LUNs for ur databases and then setup the windows cluster between them. In the cluster, create a resource group for sql server installation and begin sql server installation!!
If windows cluster is setup correctly, follow the link below to get an understanding of sql server cluster installtion.
http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx
April 6, 2010 at 11:07 am
rkinney-802645 (4/6/2010)
I have 2 servers
Do you have a SAN or shared external array? You need one or the other for a cluster.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:07 am
The servers need to be setup as a cluster before you can install SQL Server as a failover cluster.
April 6, 2010 at 11:11 am
rkinney-802645 (4/6/2010)
I don’t have a test server for testing Clustering.Ron
I would very strongly reccomend againt setting up a cluster using two production servers. You have no test environment. You will simply end up breaking current production. Try log-shipping or mirroring as an HA solution.
You need to build a cluster from scratch, not just two existing SQL Servers.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:36 am
Yes, I have SANs
April 6, 2010 at 11:37 am
Instance2 will be placed into the cluster first
April 6, 2010 at 11:39 am
then setup clustering between the two servers. Once it is successfully done, start with sql setup. Follow the link i gave earlier.
April 6, 2010 at 11:41 am
rkinney-802645 (4/6/2010)
Instance2 will be placed into the cluster first
These are currently running production, right? Have you thought out what might happen if something goes wrong while you are building the ill-conceived cluster out?
You are already running SQL on both of your existing servers. Something is likely to break, you will then be up the creek without a paddle.
Why is it that you want to cluster these existing production servers?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:45 am
Have to to install on production - no log shipping, no mirroring It budget is gone.
April 6, 2010 at 11:45 am
If these are production servers, then strict no-no to do any kind of testing on them or else if something goes wrong u'll find urself nowhere.
April 6, 2010 at 11:50 am
rkinney-802645 (4/6/2010)
Have to to install on production - no log shipping, no mirroring It budget is gone.
There is no safe way to do it. It's production. You have two stand-alone production servers that you want to cluster...Any attempt to do it will lead to serious downtime and possibly the loss of one or both servers if you do *anything* wrong.
You really need to explain to management that this goes beyond not following best practices, this is...I don't have the words.
Good luck if you try it, I would be readying my resume if I were you.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 6, 2010 at 11:52 am
Okay,
Thank you for your help.
Thanks,
Ron
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply