Solved

Help Creating a Failover SQL Cluster Server 2008  R2

Posted on 2014-11-02
5
114 Views
Last Modified: 2014-11-08
I am a beginner at configuring a SQL cluster.  I have done so for a DHCP cluster previously.

My questions are:

- The most important question:  Do you run the failover clustering configuration in Server 2008 R2 server manager first before installing SQL or do you install and configure SQL 2008 on one or both nodes on the two servers your going to cluster first, then run the Failover cluster management configuration in server manager?

- Do you run failover cluster manager on one or both servers prior to configuring your cluster?

- When do you connect to the SQL database?  I am going to be importing a backup of another database.  Does it go on both servers in the cluster prior to creating the cluster?

- When you set up iSCSI and attach it to the two servers, does it matter if the drive letters match?

- does the IP of the second nic need to be a private ip such as 192.168.X.X or does it need to be on the same subnet as NIC 1 which is the actual server management IP?

-  Does the cluster IP need to have an IP that matches the 2 servers subnets or an IP that matches the 2nd nic which i'm guessing is used for heart beat purpuses?

Do you have to install the application server role on each server prior to setting up the cluster ?

- Any other important information you can point out?

Thanks in advance.
0
Comment
Question by:Conrad_Bel
[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
  • 3
  • 2
5 Comments
 
LVL 2

Expert Comment

by:MadHatterAdmin
ID: 40418144
1. You need to configure shared storage. One drive for quorum, one for the database and one for logs.

2. Once both nodes are configured for the cluster, cluster manager can be ran from any client or each node.

3. Drive letters need to match

4. Remember that storage hence data is shared betweeen both servers but at any given point in time only one host is the active cluster node, hence holding control of the data when you restore a database it will be restored to the active cluster node

5. I would recommend both servers be on the same subnet

6. If you have a server vlan, the heartbeat can traverse management traffic. If these are virtual servers create you can also create a standalone vswitch for heartbeat traffic or run a crossover cable to a dedicated nic. There's more than one way to skin a cat but it doesnt have to be on the same subnet

7. Once the cluster is setup and tested that u can fail between shared disk. Run the sql server installation and select the cluster option. Once the sql installation completes successfully, you need to run the setup on the other host with the cluster option and the sql installtion will do everything else for you.

Reference this video to get you going:

https://www.youtube.com/watch?v=x1zlS5OAuWA
0
 

Author Comment

by:Conrad_Bel
ID: 40427369
Great,
Another question:  When i create the DTC should it be assigned to it's own disk?  Should i create a disk solely for the DTC?
0
 
LVL 2

Accepted Solution

by:
MadHatterAdmin earned 500 total points
ID: 40427909
If memory serves me right the DTC will be grabbed by the active cluster node so i would created a shared disk for this also. I'll allow someone else to chime but i dont see it hurting anything putting it on shared disk.
0
 

Author Comment

by:Conrad_Bel
ID: 40429016
Thanks for all your input madhatter.  Have a great day.
0
 
LVL 2

Expert Comment

by:MadHatterAdmin
ID: 40430413
no problem and i hope you get everything going.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
BgInfo help 5 60
T-SQL: Stored Procedure Syntax 3 31
Need help with a query 14 36
Need to trim my database size 9 19
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

756 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