Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-cluster]

9 questions
3
votes
4 answers

Upgrade SQLServer 2008 hardware

Forgive me if I'm not able to be totally clear here. It is not intentional, I'm a senior level developer in a very small company having to act like a manager at the moment. Anyway, the story is that we have 2 older dell servers with SQL Server 2008…
John
  • 177
  • 1
  • 7
2
votes
1 answer

Scalability in a High Availability Environment - SQL Failover Cluster 2012

I have created an environment where 1 SAN is connected with 2 Nodes (part of SQL Server 2012 Failover Cluster) of SQL Server. Windows Server 2008 R2 is used, and single DB is stored in SAN. We have achieved High Availability with 2 nodes and since…
Ashish Jain
  • 123
  • 4
2
votes
3 answers

Sql Server 2005 cluster - unable to rename to old server name

We have a sql 2005 cluster on W2K8 cluster. It is a named instance say SRV1\A. Then I built a new W2K8 (with a diff cluster service name) but the same service account. Then I installed a new sql 2005 cluster say SRV2\A. Now when I bring down the sql…
Paul2020
1
vote
0 answers

Overlay Network on Windows Server 2016 for WSFC + SQL Server HA

I'm trying to create an Overlay Network on Windows Server 2016 to create a separate address space for Windows Server Failover Clustering (WSFC). This cluster will eventually be used to host a SQL Server HA Cluster. Reason for doing this: The 2…
Bhavit Naik
  • 21
  • 1
  • 5
1
vote
1 answer

SQL cluster instance names for large project

We're setting up two clusters. One dev and one prod. The Production will host two SQL instances - a OLTP and a DW. The development will host 4 OLTP non-production environments and at least one DW non-production. We're working on getting more DW…
Sam
  • 1,990
  • 1
  • 14
  • 21
0
votes
2 answers

SQL 2008R2 Failover Cluster without File Share

We are looking to set up a failover cluster for our SQL 2008R2 database. To accomplish this, we have 2 servers, both equipped with Fusion I/O cards that will both have identical copies of our production databases on them. From everything I've read,…
RockiesMagicNumber
  • 123
  • 1
  • 5
0
votes
0 answers

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ASAP if disaster happens. We requested our managed…
Alex Aza
  • 101
  • 2
0
votes
1 answer

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two TITLE: Microsoft SQL Server 2012 Service Pack 1…
Eric Herlitz
  • 588
  • 2
  • 9
  • 19
0
votes
0 answers

Proper quorum configuration with a 3-node Windows cluster where only 2 nodes can take ownership

We operate a 3 node Windows cluster to add HA capability to SQL Server. In this cluster 1 of the 3 nodes is a "reporting" server and is configured to never take ownership of the cluster. At the moment we have one node (node1) and the file share…
Sam Storie
  • 101
  • 2