1
vote
1answer
70 views

Failover Cluster Client Access Point Only Responds to Pings on the Owner Node

Background We're running two VMs (Windows Server 2012 R2) on Azure with SQL Server installed, set up as an availability group. We also, of course, have another VM as a dedicated DC. These are all ...
1
vote
1answer
35 views

Failover clustering or Network Load Balance on windows server

I have 2 servers with Windows 2008 R2 standard OS. I need to create a cluster in case on of the servers goes down ; so the other one will continue provide services. The services we mostly use are a ...
0
votes
0answers
32 views

SQL Server 2008R2 multi instance Cluster with mutual active/passive

I'm looking for a way to set up an 2008R2 SQL Server with an multi instance Cluster which serves mutual active/passive. So basically two nodes where each one holds half of the databases active and ...
2
votes
0answers
35 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 ...
0
votes
2answers
157 views

Just a few questions about Hyper-V virtual machines and clustering

I have been using Microsoft’s Hyper-V technology for a little while now, but I am just now dipping my toe into clustering. In particular, I am trying to implement a fault-tolerant SQL DB. This ...
0
votes
1answer
61 views

SNMP walk on Virtual Ip not working? what can be the reason

I have two MSSQLcluster, at a time VIP [virtual ip] that will be assigned to on of the master. The problem is when i try to do any snmpwalk on VIP from a different machine its returning me a time out. ...
0
votes
1answer
132 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 ...
1
vote
2answers
37 views

2008 Clustered Services (SQL) to 2008 R2 Clustered Services

I've found plenty of articles for upgrading SQL in a clustered environment from SQL 2008 to SQL 2008 R2. However, I have not found much information in relation to migrating a current Server 2008 ...
0
votes
1answer
575 views

SQL Cluster P2V Physical to Virtual Migration tips?

Need tips for those migrating a MSSQL cluster to a single Hyper-V guest VM. Context: these are P2V (Physical to Virtual) of only one node, taking a snapshot of all drives and dismantling/destroying ...
1
vote
2answers
979 views

How to set up Zabbix to monitor SQL Server Failover Active-Passive Cluster?

It should be simple, so it is just most likely my approach being totally off and someone will hopefully prod me into the right direction. We have a Zabbix 2.0.3 server instance set up monitoring a ...
4
votes
1answer
156 views

How does a SQL Server Availability Group decide on which secondary will become the new primary when an automatic failover is triggered?

How does a SQL Server Availability Group with multiple synchronous-commit secondary replicas decide on which secondary replica will become the new primary when an automatic failover is triggered? ...
3
votes
1answer
884 views

How do I network this Windows Failover Cluster and MongoDB Replica Set? (diagram inside)

As you can see, my two Windows Server Failover Cluster (WSFC) nodes have three network interfaces each, which connects them to three different networks : A public network A private network ...
1
vote
0answers
199 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
377 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
766 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
138 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
2answers
120 views

load balanced server farm in php with sql

What is the best configuration for a load balanced server farm for a high demand download web page that uses php and mysql. I have servers that currently use centos with lightppd. Has anyone got ...
0
votes
3answers
240 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 ...
0
votes
1answer
258 views

Is it possible to install SQL instances with different Collations in a SQL Cluster

We have a two node active-active SQL Server 2008 Cluster. Running on Windows Server 2008 R2. The three excisting instances have Latin1_General_CI_AS as the Server Collation. I need to add an instance ...
0
votes
2answers
688 views

loadBalancing/clustering on IIS/ASP.Net/SQL Server

I've to create an offer for a future ASP.NET application. They wants an high availability(99.9%+). So I'm searching the best solutions with .Net technologies(asp.net mvc 3, IIS 7, SQL Server 2008 R2) ...
3
votes
2answers
116 views

Windows Cluster - Can I failover without disturbing SQL?

I have a 3 node cluster. All of the nodes are part of Cluster01 in what should be A/A/P mode. Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows ...
1
vote
2answers
71 views

MSSQL enterprise cluster - track of failovers

In an MSSQL Enterprise cluster where can I find a log of past fail over events (when they happened and which instances were re-assigned?)
0
votes
2answers
92 views

Why do you need more than two node cluster

Why anyone would need more than two node cluster? Cluster to my understanding is to provide HA ( not load balancing ). Having multisite two node cluster should provide you enough HA. I tried ...
0
votes
3answers
618 views

Multiple Active Nodes with SQL Server 2008 R2

Is this possible either out of the box or using additional tools or frameworks? I'm looking to set up at least two simultaneously active machines to better understand how high scalability for ...
14
votes
7answers
2k views

When is the right time to introduce high availability for web site?

When is the right time to introduce high availability for web site? There are many articles on High Availability options. It’s not that obvious however WHEN is the right time to switch from single ...
1
vote
1answer
74 views

clustering MS SQL 2008 [duplicate]

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the ...
1
vote
1answer
340 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
2
votes
2answers
2k views

How do you setup a SQL 2005 cluster in amazon EC2?

I am trying to setup a highly-available DB architecture in an EC2 servers. We are forced to use SQL 2005 for now. What kind of solutions would work in this context? Has anyone done it? I can't ...
0
votes
2answers
715 views

Sql server active/passive vs active/active clustering

What is the difference between SQL Server clustering methods: - Active/Active - Active/Passive in simple worlds and an example usage scenario per method...
5
votes
1answer
352 views

Windows Server Cluster & Strange Day Light Savings Time Behaviour

Over the weekend (Sunday March 27th) Daylight Savings Time kicked in here in Ireland and so all the servers (all win2k3 server) in our Production Environment updated their Times +1 Hour. However ...
0
votes
1answer
82 views

Distributed Microsoft SQL server deployment - Cluster?

I have a website, I want to host on two diffident very far deployments. I have a rather good connection between them. But the users have a good connection only to what's near them. My Idea is to ...
0
votes
2answers
403 views

Do I need to buy Mysql cluster enterprise edition? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? we have a ms-sql 2008 standard edition. The db became too huge, about 8 10^9 records.the db files are about 4.5tb ...
0
votes
3answers
2k views

Failover clustering: tempdb on SAN?

We are considering clustering our SQL Server 2008 EE instances. The storage is on SAN. Can we put tempdb data/log files on SAN? What are the pros and cons on this solution? For optimal performance, ...
0
votes
1answer
972 views

Install Reporting Services 2K8R2 on W2K8R2 Cluster Nodes

First I'm aware that Reporting Services is not Cluster aware, But I would like to install it on my each node of my 2 node Cluster on the default instance. I've got the following error installing ...
2
votes
1answer
2k views

Windows Server 2008 Cluster Errors

We have a couple dozen Win2008 and 2008R2 Enterprise clusters that are used for SQL Server 2008 and 2008 R2 Enterprise/Datacenter. In the past we have had many issues with random failovers and ...
3
votes
1answer
1k views

Are there problems teaming the public network adapters on a Windows Server 2008 R2 failover cluster?

We have a two-node Windows Server 2008 R2 fail-over cluster that's hosting about a dozen instances of SQL Server. The nodes each have four network adapters in them (a pair of dual-port Broadcom ...
0
votes
1answer
105 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 ...
4
votes
3answers
300 views

SQL Server 2008 Fail-over Cluster

I am using SQL Server 2008 Enterprise and I want to install SQL Server 2008 fail-over Cluster. I am wondering, (1) do I need an active directory domain? (2) what is the minimal number of machines do ...
1
vote
5answers
2k views

Best way to improve disk performance (SQL Server 2000)

I am having some disk access issues on a web application. The main load is many concurrent inserts/updates/selects on large tables. It is currently a single 2ru rackmount running SQL Server 2000 and ...
1
vote
1answer
664 views

Boost SQL Server priority: should it be used?

I'm trying to optimize my SQL Server 2008 instances on Windows cluster (on Windows Server 2008). I'm having several SQL Server instances on two cluster nodes. I was thinking that should I enable 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
1answer
88 views

Move clustered SQL from one network to another

We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway ...
0
votes
1answer
304 views

SQL Failover Cluster Management — dealing with the “cluster network name is not online”

Viewing a failover configuration in the SQL Failover Cluster Management tool, I can see via a succinct warning message that "The cluster network name is not online". Everything about the cluster ...
2
votes
2answers
901 views

High Availability with 2 servers?

Is it possible to have a high availability setup with 2 servers? Running Windows Web Server 2008 and MSSQL Web Edition (as I know Express isn't supported)? Getting to the point where our one ...
3
votes
4answers
1k views

SQL Cluster on Hyper V Failover Cluster

We have a VM running SQL Server on a 6 node cluster of blades. The VM's data files are stored a SAN attached using a direct iSCSI connection. As this SQL server will be running a number of important ...
3
votes
3answers
593 views

Windows SQL Server Cluster Failover Without Disruption

Is MS SQL server clustering capable of performing a seamless fail over between nodes? That is, where the clients wouldn't notice anything had changed except perhaps a short delay during the ...
2
votes
2answers
620 views

Sql Server hd - seek time vs sequential, SAN vs DAS

I need to buy a new server destined for Navision 2009 database on SQL Server 2008. Database is 50GB large and growing 10 GB a year. I'm considering to create a cluster on 2 servers. Didn't decided yet ...
3
votes
3answers
577 views

SQL Server Cluster Performance

Can anybody help me answer what I hope is a really simple question? Assume I have an application running against a SQL Server database, and I am running performance tests. Should I expect improved ...
1
vote
2answers
80 views

Is it possible to replicate/cluster two different databases

I would like to know if it's possible to replicate or cluster a table between mssql and mysql. That could be usefull during a migration process.
1
vote
3answers
596 views

Experience with asymmetrical (non-identical hardware) SQL Server 2005 / Win 2003 cluster

I am reasonably good at dealing with SQL Server clusters; I am wondering if folks have experience, good or bad, using a mix of different models of servers from the same vendor in one SQL 2005 cluster. ...