SQL Server Failover Clustering or DB Mirroring
Hi, I need to clarify some concerns with regard to the options available on SQL Cluster deployment, but before that let me give you a background on the infra layout so we are on the same page: We have two physical servers + FC SAN (iscsi not supported in the current model) to [...]
Answer Question
| February 28, 2012 9:55 AM
Failover Clustering, Hyper-V, SQLServer
Hi, I need to clarify some concerns with regard to the options available on SQL Cluster deployment, but before that let me give you a background on the infra layout so we are on the same page: We have two physical servers + FC SAN (iscsi not supported in the current model) to [...]
Answer Question
| February 28, 2012 9:55 AM
Failover Clustering, Hyper-V, SQLServer
SQL Server Fails to Start When Moved to Different Node
Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the [...]
Answer Question
| April 11, 2011 5:24 PM
Failover Clustering, Failover Clustering nodes, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server clustering, Windows Server 2008 R2
Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the [...]
Answer Question
| April 11, 2011 5:24 PM
Failover Clustering, Failover Clustering nodes, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server clustering, Windows Server 2008 R2
When setting up a cluster for failover purposes do you only inclde hardware of one vendor?
When setting up a cluster for the purpose of failover do you only include in that cluster servers made by the same vendor or can you mix vendors?
Answer Question
| October 1, 2010 12:59 PM
Clustering, Failover Clustering, Server Cluster, Vendor management, Vendor selection
When setting up a cluster for the purpose of failover do you only include in that cluster servers made by the same vendor or can you mix vendors?
Answer Question
| October 1, 2010 12:59 PM
Clustering, Failover Clustering, Server Cluster, Vendor management, Vendor selection
Counting failovers
I would like to count the automatic failover that occur in my server pool each month. I don’t want the switchovers that are done manually just the failovers, Does anyone have a suggestion where I might find that information recorded. Will it be in the event file of the reciving server or do I need [...]
Answer Question
| April 25, 2010 5:53 PM
Failover, Failover Cluster Management, Failover Clustering, Servers
I would like to count the automatic failover that occur in my server pool each month. I don’t want the switchovers that are done manually just the failovers, Does anyone have a suggestion where I might find that information recorded. Will it be in the event file of the reciving server or do I need [...]
Answer Question
| April 25, 2010 5:53 PM
Failover, Failover Cluster Management, Failover Clustering, Servers
Is there any danger?
In an active to active environment with multiple nodes is there any possibility that a failover of one node could take down all of the nodes?
Answer Question
| April 16, 2010 12:05 PM
Failover, Failover Clustering, Failover Clustering nodes
In an active to active environment with multiple nodes is there any possibility that a failover of one node could take down all of the nodes?
Answer Question
| April 16, 2010 12:05 PM
Failover, Failover Clustering, Failover Clustering nodes
Failover of a virtualized server
Assume that a virtualized server running five virtual machines has a hardware failure that takes the physical device down, in an active to active failover enviroment of multiple nodes do all the virtual machines failover to the same node in a cluster or could each virtual machine go to a different node? If a single machine in [...]
Answer Question
| April 19, 2010 12:01 PM
Failover, Failover Clustering, Failover Clustering nodes, Server virtualization
Assume that a virtualized server running five virtual machines has a hardware failure that takes the physical device down, in an active to active failover enviroment of multiple nodes do all the virtual machines failover to the same node in a cluster or could each virtual machine go to a different node? If a single machine in [...]
Answer Question
| April 19, 2010 12:01 PM
Failover, Failover Clustering, Failover Clustering nodes, Server virtualization
Active to active failover assumption
Is it assumed that in an active to active failover involving two or more nodes that there will always be a node that can receive the failover? What happens if there isn’t a node that can receive the failover because the other nodes are all maxed out? I can understand why in an active passive [...]
Answer Question
| April 19, 2010 11:47 AM
Failover, Failover Clustering, Failover Clustering nodes
Is it assumed that in an active to active failover involving two or more nodes that there will always be a node that can receive the failover? What happens if there isn’t a node that can receive the failover because the other nodes are all maxed out? I can understand why in an active passive [...]
Answer Question
| April 19, 2010 11:47 AM
Failover, Failover Clustering, Failover Clustering nodes
Failover Cluster Management
What does failover cluster management refer to? Is it a function, as in something a person does or is it a facility as in something someone uses?
Answer Question
| April 16, 2010 11:39 AM
Failover, Failover Cluster Management, Failover Clustering
What does failover cluster management refer to? Is it a function, as in something a person does or is it a facility as in something someone uses?
Answer Question
| April 16, 2010 11:39 AM
Failover, Failover Cluster Management, Failover Clustering
Cost per server of the failover software?
What is the cost per server of the software that enables failover? Does the cost change if the failover is active-active or active passive? Does this software have a specific class name?
Answer Question
| April 16, 2010 11:31 AM
Failover, Failover Clustering
What is the cost per server of the software that enables failover? Does the cost change if the failover is active-active or active passive? Does this software have a specific class name?
Answer Question
| April 16, 2010 11:31 AM
Failover, Failover Clustering
Why failover applicantion software failures?
Mrdenny, says that if a cluster resource is configured to failover then it will failover on an application program that fails, but does that make sense? if the application program failed processing a specific transaction on one server isn’t it going to fail processing the same transaction on another server?
Answer Question
| April 16, 2010 11:25 AM
Failover, Failover Clustering
Mrdenny, says that if a cluster resource is configured to failover then it will failover on an application program that fails, but does that make sense? if the application program failed processing a specific transaction on one server isn’t it going to fail processing the same transaction on another server?
Answer Question
| April 16, 2010 11:25 AM
Failover, Failover Clustering
Does failover automatically occur when an application software fails?
Does failover automatically occur when an application software fails? What other types of failures does failover not get triggered by?
Answer Question
| April 16, 2010 9:27 PM
Failover, Failover Clustering
Does failover automatically occur when an application software fails? What other types of failures does failover not get triggered by?
Answer Question
| April 16, 2010 9:27 PM
Failover, Failover Clustering
Choosing between failover options
It seems of the two choices, failover to an active server within a cluster, or failover to an inactive backup standby server, the economic chose would be the former. With the former, the servers in the cluster are all doing productive work while they also act as backup for the other servers in the cluster. [...]
Answer Question
| April 9, 2010 11:40 AM
Failover, Failover Cluster Management, Failover Clustering
It seems of the two choices, failover to an active server within a cluster, or failover to an inactive backup standby server, the economic chose would be the former. With the former, the servers in the cluster are all doing productive work while they also act as backup for the other servers in the cluster. [...]
Answer Question
| April 9, 2010 11:40 AM
Failover, Failover Cluster Management, Failover Clustering
What kind of failure event would cause a primary server to failover to a standby backup?
I am aware that in a situation where a primary server is being backed-up by a standby server that the standby server is constantly testing the pulse beat of the primary, what kind of problem will cause a failover to take place. Is it only when the primary stops functioning, does it have to stop functioning [...]
Answer Question
| April 11, 2010 9:46 PM
Failover, Failover Clustering, pulse beat testing
I am aware that in a situation where a primary server is being backed-up by a standby server that the standby server is constantly testing the pulse beat of the primary, what kind of problem will cause a failover to take place. Is it only when the primary stops functioning, does it have to stop functioning [...]
Answer Question
| April 11, 2010 9:46 PM
Failover, Failover Clustering, pulse beat testing
Standby server back-up process
Assuming that I am in a situation where a primary server is backed-up by a standby server that is testing the pluse beat of the primary. From the instant the backup senses the that the primary server is no longer functioning, how long would you expect it would take for the the backup to be [...]
Answer Question
| June 11, 2012 9:35 PM
Backup & recovery, Failover, Failover Clustering, Server administration, Server Backup
Assuming that I am in a situation where a primary server is backed-up by a standby server that is testing the pluse beat of the primary. From the instant the backup senses the that the primary server is no longer functioning, how long would you expect it would take for the the backup to be [...]
Answer Question
| June 11, 2012 9:35 PM
Backup & recovery, Failover, Failover Clustering, Server administration, Server Backup
Will a server reboot trigger a failover?
If I have a situation where I am backing up a server by failing over to a backup standby inactive server that is performing no other function other than testing the pluse beat of the primary server. If someone causes the primary server to be rebooted is there any chance that the backup server will [...]
Answer Question
| April 8, 2010 6:29 PM
Backup Server, Failover, Failover Clustering, Server Reboot
If I have a situation where I am backing up a server by failing over to a backup standby inactive server that is performing no other function other than testing the pluse beat of the primary server. If someone causes the primary server to be rebooted is there any chance that the backup server will [...]
Answer Question
| April 8, 2010 6:29 PM
Backup Server, Failover, Failover Clustering, Server Reboot
What is the difference between failover and failover clustering
What is the difference between failover and failover clustering?
Answer Question
| April 6, 2010 3:49 PM
Failover, Failover Clustering
What is the difference between failover and failover clustering?
Answer Question
| April 6, 2010 3:49 PM
Failover, Failover Clustering
Which task does the backup server do?
As I understand the theory of automated failover, you backup a primary server with a secondary standby server that monitors the pulse-beat of the primary and automatically takes over when the primary server fails. My question is if the primary server is performing a search and experiences a hardware failure that stops the search from [...]
Answer Question
| April 7, 2010 3:37 PM
Backup Server, Failover, Failover Clustering, Server administration
As I understand the theory of automated failover, you backup a primary server with a secondary standby server that monitors the pulse-beat of the primary and automatically takes over when the primary server fails. My question is if the primary server is performing a search and experiences a hardware failure that stops the search from [...]
Answer Question
| April 7, 2010 3:37 PM
Backup Server, Failover, Failover Clustering, Server administration
Does automated failover defeat the purpose of virtualization?
My understanding of the purpose of virtualization is to reduce server sprawl. In theory if you get one physical server to do the work of two servers you increase the percent of utilization of the server while cutting down on the number of servers in the pool, thus reducing power consumption, cooling needs, data center [...]
Answer Question
| April 7, 2010 3:31 PM
Failover, Failover Clustering, Virtual Server Administration, Virtualization
My understanding of the purpose of virtualization is to reduce server sprawl. In theory if you get one physical server to do the work of two servers you increase the percent of utilization of the server while cutting down on the number of servers in the pool, thus reducing power consumption, cooling needs, data center [...]
Answer Question
| April 7, 2010 3:31 PM
Failover, Failover Clustering, Virtual Server Administration, Virtualization
What is the maximum size of nodes?
The following is the definition of from Wikipedia for “high-availability cluster” High-availability clusters (also known as Failover Clusters) are implemented primarily for the purpose of improving the availability of services that the cluster provides. They operate by having redundant nodes, which are then used to provide service when system components fail. The most common size [...]
Answer Question
| April 7, 2010 3:25 PM
Failover, Failover Clustering, Failover Clustering nodes
The following is the definition of from Wikipedia for “high-availability cluster” High-availability clusters (also known as Failover Clusters) are implemented primarily for the purpose of improving the availability of services that the cluster provides. They operate by having redundant nodes, which are then used to provide service when system components fail. The most common size [...]
Answer Question
| April 7, 2010 3:25 PM
Failover, Failover Clustering, Failover Clustering nodes
Failover questions for servers
Is the failover of a server in a server cluster immediate? Is there reason to believe that that a failover in a virtualized cluster is faster than a failover in a non-virtualized cluster? What role does provisioning play in the speed of a failover? Is there a limit to the size of a server cluster? [...]
Answer Question
| April 2, 2010 2:26 PM
Failover Clustering, Server Cluster
Is the failover of a server in a server cluster immediate? Is there reason to believe that that a failover in a virtualized cluster is faster than a failover in a non-virtualized cluster? What role does provisioning play in the speed of a failover? Is there a limit to the size of a server cluster? [...]
Answer Question
| April 2, 2010 2:26 PM
Failover Clustering, Server Cluster
