Solved

Create cluster from existing SQL 2008 R2 server?

Posted on 2013-01-23
5
587 Views
Last Modified: 2013-01-23
Hello experts,

I have an existing SQL 2008 R2 database server (standard) running on Windows 2008 R2 (enterprise). I want to cluster this server with another. Is this possible or does SQL have to be installed as a cluster in the first place for this to work?

Regards,
PMIMIS
0
Comment
Question by:PMIMIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 33

Accepted Solution

by:
knightEknight earned 250 total points
ID: 38811730
Server clustering is done at the OS level, and then you install a clustered SQL instance on top of that.  I'm not saying "no way", but IMO you would save yourself a lot of trouble by provisioning a clustered server first and then migrating your SQL Server to it.
0
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 250 total points
ID: 38811820
You can definitely still cluster-enable the OS in this case, but as the previous poster mentioned, enabling clustering on the OS and clustering an application are two different things. In theory, you can cluster any service at all, even if it's not specifically cluster-aware - in the case of SQL Server, though, there's a specific cluster installation process that sets up the clustering for you (though to be fair, I've never clustered a previously stand-alone instance of SQL Server, so I'm not sure how that would go).

I'd recommend that you configure clustering on the OS between your two servers, and then install a clustered instance of SQL Server, using the specific segment of the SQL installer designed for it. Once you've gone that, you can migrate your users and databases to the new clustered instance.

To try and help clear things up, I did a post a while back that explains some different terms in clustering - there's some confusion around what it means to enable clustering on an OS vs. clustering an application. Not sure if it will help in this case, but I wanted to put it out there:

http://trycatchfinally.net/2012/09/clearing-up-windows-cluster-terminology/
0
 

Author Comment

by:PMIMIS
ID: 38812299
Thanks to both of you. I wish I had known this before hand. I had thought the SQL server could be enabled for clustering after the initial install.

Looks like after I cluster the OS I will install a clustered instance of SQL and migrate my databases over.

My new SharePoint servers already point at this existing database. Any thoughts on what I will have to do to make sure they happily see the database once it is moved to the clustered instance?
0
 

Author Closing Comment

by:PMIMIS
ID: 38812315
Both experts gave me great information in a very timely fashion. knightEknight gets the nod for best solution by virtue of being complete and first, while ryanmccauley gets half the points for adding significant depth and explanation to the first answer.
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38812772
I've not ever moved a Sharepoint deployment from one SQL Server to another, but in the research I've done (we'll have to do it soon), it looks as though you need to move it between two servers at the exact same version and patch level (like SQL 2008 SP2 -> same). The easiest thing to do is set up a DNS alias (or a local SQL Alias on the web servers) that points the old server name to the new one, so the configuration doesn't require any changes - kind of ugly, but requires the least intervention.

Good luck!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question