0
votes
0answers
170 views

SQL Failover Cluster Resource DNS Registration Failure

I've got a cluster I migrated from one location to another (new IPs). I've moved a few other clusters like this recently with no issues. This recent cluster all came up fine except one 2012 instance. ...
2
votes
0answers
40 views

SQL Failover Cluster IP Migration

I have a four node cluster setup which I need to migrate from subnet A to subnet B. The cluster has roughly 12 instances running on it. I've found articles to update the SQL Cluster IP, but I've got ...
1
vote
1answer
107 views

How to make clustered storage available from SAN to Hyper-V for two node cluster

I want to make a 2 node SQL Server 2012 cluster. Both nodes are virtual machines running Windows Server 2012 on Hyper-V. I have a physical SAN available which I can use for clustered storage so I was ...
0
votes
1answer
42 views

Two SQL Failover Clusters in two-node failover servers

I need 2 SQL Failover clusters: Core Database Cluster: this contains all of my core application databases Analytic Database Cluster: this contains my web analytic database Now, I only have 2 ...
0
votes
1answer
218 views

Failover Cluster Migration Wizard (SQL Install Portion)

Have 5 SQL 2005 to 2008 R2 clustered instances. I've setup a new cluster to prepare to use the cluster migration wizard. As I understand it you have to install SQL before running the cluster migration ...
0
votes
1answer
132 views

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...
0
votes
1answer
35 views

script\cli steps to add a mounted snapshot to failover cluster for SQL server

I know the following setups use cluster resource and create a physical disk Assign Disk Signature Add dependency of SQL of the new disk bring the disk online I am not sure if these are the right ...
1
vote
1answer
2k views

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the ...
1
vote
0answers
224 views

SQL Server 2008 R2 cluster on Windows Server 20008 R2 issue

I have a SQL Server 2008 R2 cluster on Windows Server 20008 R2. There are 2 nodes node1 and node2 in the cluster. When I start node1 and node2, I get the following statue information from them: From ...
1
vote
1answer
418 views

What's the right way to shutdown a SQL Server 2008 R2 cluster?

I'm new to SQL Server 2008 R2 cluster. I just created a test environment now I need to shut it down. I know SQL Server cluster is a high availability solution so there is seldom mentioned that how to ...
2
votes
1answer
910 views

SQL Server 2008 R2 cluster, “available storage” shows “offline”

I've installed a SQL Server 2008 R2 cluster and I found the resource group "available storage" shows "offline" status. What does it mean? It seems I can't take it online. I tried to use the cluster ...
1
vote
1answer
139 views

SQL Server 2008 R2 cluster installation, can I install on the 2 nodes at the same time?

I've configured the Windows cluster, now I need to install SQL Server on the 2 nodes. To save time, I want to know if I can install on the 2 nodes at the same time? Thanks
0
votes
3answers
254 views

“Virtual” shared storage for SQL Server 2008 R2 Cluster

I am trying to set up a virtual test environment for a SQL Server 2008 R2 Cluster (2 nodes) running on Hyper-V. The cluster requires a shared storage to function properly, however in this test ...
2
votes
2answers
339 views

Query another cluster group from SQL server?

Is there a way to query from SQL Server in TSQL which node is active in another cluster group in the same cluster? I have a cluster with two cluster groups, one with resources for SQL Server, one ...
0
votes
1answer
51 views

Advanced SQL Setup

Got a major issue that I need some help with. Here is the situation. The client has multiple web sites hosted on multiple web servers (virtual machines) running on multiple virtual hosts that ...
1
vote
2answers
400 views

MSSQL Failover Witness Server on a Domain Controller

I have 3 servers 1 production 1 standby and 1 just sitting there. I want 1 to stay production and I have been working on setting up an MSSQL automatic failover cluster between the production server ...
0
votes
1answer
107 views

SQL Server 2008 setup issue

I am setting up SQL Server 2008 fail over cluster on Windows Server 2008 Enterprise. I met with the following issue during setup process. Here is detailed message, any ideas what is wrong? The ...
2
votes
2answers
292 views

Can I use domain controller as one of my nodes in my cluster environment?

I want do some SQL Server failover cluster experiment on Windows 2008 R2 in VM. Now I created a domain controller(as DNS server too) DC. Also I created a server server1 and added into the domain. Can ...
2
votes
4answers
438 views

SQL server failover clustering

How many failover clustered nodes can you have?, and if you add more and more nodes, is it going to slow down?