December 27, 2010 at 12:01 am
Hi,
I have been assigned to install SQL on a cluster by my boss. Where should the dlls, data file and log file be installed. It is connected to SAN.
Please advise. I will be doing this for first time and would really apprecaite your helps.
Thank you
December 29, 2010 at 12:55 pm
gttred,
In order for you to install SQL Server clustering, you need at least 2 node of Windows clustered servers. SQL Server 2008 Clustering lived on top of Windows clustering (please forgive me if I don't state this correctly). To answer your queston on the location of the data files and log, normal rules apply. Separate log and data files on its own drive. the binary could still be installed on C: drive, but make sure you have separate drives for System databases, TempDB and a Witness disk. All of these disks should be part of a cluster resource which your Windows Admin should be able to set it up for you, unless you're also the Windows admin :-P. Here's a page detailing how to setup a Windows 2008 Clustering: http://blogs.msdn.com/b/clustering/archive/2008/01/18/7151154.aspx.
There are several pages you could read through for setting up SQL Server 2008 Clustering. Here's one on requirements and prep work before installing SQL Server 2008 clustering: http://msdn.microsoft.com/en-us/library/ms179410(v=SQL.100).aspx.
Here's a link to the actual SQL clustering setup: http://msdn.microsoft.com/en-us/library/ms179530(v=SQL.100).aspx.
Those links are Microsoft documentation on failover clustering.
From my own experience installing SQL Server 2008 clustering, here's a couple of tips:
- Slipstreamed SP1 to your 2008 SQL Server Setup, this will save you a lot of headaches.
- Read the requirement for the cluster service accounts. Cluster service accounts required Domain Admin rights which is a policy violation in my company, and I think in most companies too. Work around is to manually create the SPN for the cluster Service account.
Well I hope this helps.
Harry Chandra
December 30, 2010 at 3:31 pm
gttred (12/27/2010)
Hi,I have been assigned to install SQL on a cluster by my boss. Where should the dlls, data file and log file be installed. It is connected to SAN.
Please advise. I will be doing this for first time and would really apprecaite your helps.
Thank you
Install all shared components to the C drive as there is a known issue during cluster installation when completing the add node action. The installer installs the shared components to C: despite previously selecting drive D: for instance. This is fixed in SP1 CU 10 so you could always slipstream these updates to bypass the issue and use your chosen drive. There are certain components that will always be installed to C: because this is generally the first system drive available during boot time.
If you have never installed a clustered SQL server instance before i would strongly suggest you go though this process in an offline environment!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2011 at 5:50 am
If you are installing SQL Server 2008 then FineBuild can do the SQL cluster install for you.
If you are new to clustering, then you will face a steep learning curve. Clustering introduces many new and interesting ways to trash your server, and it is a lucky person who does not hit some of these as they gain experience in clustering.
Perry's advice about practicing the install process before hitting your production servers is good. Try to get a cluster set up on Hyper-V or VMWare and run a few installs. Try various failover scenarios and see if anything breaks and what you have to do to fix it.
Finally (but you should do this first), verify that a clustered solution is the the right way to fix the problem you are trying to solve. Clustering for SQL Server is a high-availability solution, not a business continuity (DR) solution. For many people Mirroring is a better answer to their problems than clustering.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 6, 2011 at 11:39 am
You need to install the OS on C:\ which is a local drive. You can install SQL server on the local drive D:\ and you need to come up with a plan as to where the log files and the data files go to on the clustered disk and have them installed appropriately.
January 10, 2011 at 8:19 am
I've built a 2008 cluster earlier this year and two R2 clusters in the past few weeks so I'll throw out some links that helped me.
SQL Server 2008 R2 has a bug with clustering as well where it fails to register the SQL Server Agent service with the failover clustering service and thus the install fails. See this thread for the workaround:
Also here's a good series that demonstrates how to build a 2008 cluster from Windows Server up:
http://www.mssqltips.com/tip.asp?tip=1687
Also, if you screw up and you want to back out, DO NOT uninstall by going to control panel, uninstall software, etc. Run the installer again and remove each node one at a time:
http://msdn.microsoft.com/en-us/library/ms191545.aspx
And THEN, uninstall through control panel, uninstall software to remove shared components. Otherwise, you will have problems uninstalling cleanly.
January 10, 2011 at 10:51 pm
Thank you all for your help. I really appreciate it.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply