Questions tagged [failover]
Failover is the concept of moving services from one host or node to another in order to provide high availability in a computing system.
1
vote
1answer
28 views
Sync Login PW across Multiple Instances
When attempting to failover many logins fail due to nonmatching passwords on both instances. Is there a way for me to replicate passwords to other servers for all logins which passwords do not match.
0
votes
1answer
29 views
Azure automatic fail-over vs always on availability groups clarification
I am trying to understand automatic failover vs always on availability groups in Azure hybrid and geo-region situations:
Is it possible to have on-premises SQL databases, VM SQL databases and Azure ...
0
votes
1answer
43 views
Why is my DR AG database in the “recovery pending” state?
I am trying to build an architecture where we get automatic failover for both HA and DR for our DBs using SQL Server 2016 AlwaysOn Availability Groups. When I tested this using only one Availability ...
0
votes
1answer
31 views
Automatic fail over in Always on availability group with 3 Node in synchronous mode and 1 Node in Asynchronous Mode
I am laying out a plan where there will be 3 Node on site with automatic fail over with synchronous mode and 1 remote replica with asynchronous mode. My question is if the primary goes down which node ...
1
vote
0answers
16 views
Why use Failover replica on Google Cloud RDS?
we are thinking of migrating our MySQL database from our dedicated server to a Google Cloud RDS instance. However I would like to clarify the below:
1) What is the purpose of creating a failover ...
0
votes
0answers
70 views
Edition upgrade on SQL Server failover clustered instance
We did Edition upgrade on our active node for the SQL Server instance SQL01 and that was successful.
I have a question/doubt --> Do I need to proceed the same on other node as well since SQL Server ...
0
votes
1answer
43 views
IP address to use with FCI, Always On AG and Always On (AG) FCI
My understanding is that HA can be achieved using either of the below and my concern was which IP address should client applications use when connecting to SQL Server:
Failover Clustering: For this ...
0
votes
1answer
47 views
Automatic failover (Clustering/Always On AG)
Let's says we have 2 nodes (N1, N2) clustered (say C1) on-site. And an Always On AG is configured between this cluster C1 and a new SQL server instance N3 (N3 is off-site).
Now, if there is a problem ...
0
votes
0answers
45 views
Moving tempdb from shared to local drive in a failover cluster
We have an existing failover cluster that I would like to have the tempdb in local drive. I'm not sure how to proceed. My thought process is below:
Create two drives on each node one for tempdb and ...
0
votes
1answer
384 views
Always ON - What is the difference between the virtual cluster name and Listener
In clustering you specify DNS name/IP address of cluster that is then used by all applications. In case of failover, the same DNS name/IP address will point to the appropriate database server.
In ...
-1
votes
1answer
564 views
Always On Failover Clustering vs Always On Availability Groups
I have some concerns over my understanding of SQL Server Always On. Kindly can you correct me (conceptually) where needed:
Always On Clustering and Always On Availability Groups are 2 separate ...
1
vote
0answers
39 views
Switch-SQLAvailability error during DB Restore in AlwaysON Group
Can anyone share your inputs on below and how to fix the issue and possible causes of failure?
I am trying to restore a DB using PS script and at one step it is failing during the role change test ...
1
vote
1answer
120 views
Availability Groups Failover Readinness “No data loss” and rollback of nonqualified transactions
I have Availability Groups with Synchronous Replication and Automatic Failover setup with SQL Server 2016 SP2 in my production environment.
I want to do a manual failover for patching and I have ...
1
vote
1answer
104 views
Pausing the secondary Replicas for a day in always on availability group
We are planning to make the DR as primary and do maintenance on the secondary site(Formerly Primary Site) and hence pausing both the secondaries in always on availability group for a day. I am aware ...
2
votes
1answer
134 views
Repmgr: Error to promote Standby Cluster to Master Cluster in failover
I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover.
Following my configurations, this ...
3
votes
1answer
72 views
Any Reason to have Regular Failover Clustering in Azure Cloud?
Is there a reason to have Regular SQL Failover Clustering when database is in Azure Cloud?
I understand the benefits having Availability Groups in Azure Cloud for Database-Level protection. People ...
1
vote
1answer
37 views
Shouldn't Windows Server Failover Clustering already take care of SQLServer Failover Clustering?
After reading this question, Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?
If Windows Server Failover Clustering is installed, ...
1
vote
1answer
53 views
Azure Failover Clustering vs On Premise Failover Clustering
Azure AlwaysOn FCI Failover Clustering IaaS VMs seem to have a different diagram compared to On-Premise Failover Clustering.
Azure has two storage for 2 Vms; Traditional On-Premise contains 1 Shared ...
1
vote
1answer
55 views
Is it a common pattern in having two AlwaysOn Availability Groups for DR and Reporting?
We have a primary OLTP server in the cloud.
We intend to have Synchronous Alwayson Availability Group for Disaster Recovery,
and another Availability Group AAG for Ad-hoc Query Reporting.
This way ...
0
votes
1answer
30 views
Failover from Primary to Asyn Secondary Replica
In my environment we have 1 Primary 1 Synchornous Secondary and 1 Asynchronous Secondary Replica (Off site). We are planning to do a manual failover to the Asynchronous Secondary Replica (Off site) ...
0
votes
0answers
26 views
full backup after failover cluster stuck for 11 hours
We have 2 nodes in a cluster environment one is a physical node and the other is virtual and both servers are windows 2008R2.
the client performed a manual failover at night at about 7:30 pm(to the ...
1
vote
0answers
199 views
VMWare Windows Failover Clustering - Cluster Node Removed
We have a 2012 Windows failover Cluster set up for SQL Server 2014 on VMWare ESXi, 6.0.0, 3620759. A couple weekends ago, our Server Admin made some updates to the the UCS Manager software, which in ...
0
votes
0answers
27 views
Migrating Oracle 11G Fail Safe to new hardware? Multiple Cluster Nodes
We have a 11G 2 Node Active \ Passive Failover configuration that we want to move to new hardware.
Is it possible to have 4 nodes running temporarily while we move everything over? I.E. 1 Active and ...
1
vote
2answers
132 views
SQL Server 2014 Standard FCI Does Not Failover
Have a peculiar case where a previously working FCI, after installing a large backlog of Windows updates, is now failing often and not failing over. On occasion, and this appears to happen around ...
0
votes
2answers
142 views
How do I automatically enable or disable report jobs at AOAG failover?
I have an AlwaysOn Availability Group with 2 DB servers. I'm attempting to use SQL Server Agent Alerts to programmatically disable a handful of SQL Server Agent jobs (that must not run on a secondary) ...
2
votes
1answer
108 views
Migrating Production SQL Servers (Availability Group) from one data center to another - questions
We have two SQL servers combined into Availability Group in data center 1 (dc1):
dc1 server 1: SQL Server 2012 SP3 on Windows Server 2016
dc1 server 2: SQL Server 2012 SP3 on Windows Server 2012 R2
...
0
votes
2answers
390 views
MongoDB Replica Set Failover due to unreachable SECONDARY resulted in Rollback
I have a 3 member replica set with 1 primary, 1 secondary and 1 arbiter. Due to some apparent network issue, the secondary was unreachable. After some time, the secondary became the primary and caused ...
1
vote
1answer
195 views
do single AZ AWS RDS instances self heal?
I'm aware of "multi AZ" databases "auto failing over" if one side goes down. My question is, if you have a single AZ RDS database, and the database box "dies" does AWS automatically spin up a new one ...
2
votes
1answer
293 views
Availability Group, asynchronous mode, manual/forced failover - handling identity overlap
We have a two replica 2017 Standard Availability Group in asynchronous mode. With a failover (manual/forced, since can't do automatic), we have the potential for overlapping/reused identity values if ...
0
votes
1answer
172 views
Log Shipping failover when Primary is not accessible
Log Shipping Failover
I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible.
My Steps for failover will be
1) Copy ...
1
vote
1answer
181 views
Why configuring automatic failover for SQL availibility group feature on sql failover cluster instance not allowed
I have set up an availability group where a primary is standalone server and replica is SQL failover cluster. This setup allows me only manual failover and when ever I try to set it automatic in FCI ...
0
votes
1answer
313 views
Can auto failover cause split-brain? (SQL AlwaysOn)
I have been studying Cluster voting and AlwaysOn failover. The topic of split-brain comes up and sounds terrible. This following from Microsoft seems to indicate that only a person with SA, doing ...
0
votes
1answer
141 views
How to prevent data loss during intra-site failover
We are looking to build a MS SQL server (either SQL server 2016 standard or enterprise edition) solution but are having some troubles. This post can be lengthy and if you think it is TLDR, our ...
0
votes
2answers
287 views
SQL Failover Clustering with Availability Groups: Single or Multiple Databases
Company wants to implement AlwaysOn SQL Failover Clustering with Availability Groups, for server level and data protection.
Are arrangements below, only possible if 1 database is on the server, or ...
0
votes
1answer
300 views
Migrate from SQL 2016 Failover Cluster to Availability Groups
We have a 16 node SQL 2016 failover cluster with around 20 SQL instances and total number of databases around 600.
Since we are upgrading our hardware to Hyper-Converged infrastructure which has ...
0
votes
0answers
31 views
Unable to failover through AG Wizard in SQL Server 2014
Fail over not happened from AG wizard, selected "select new primary replica" and it is not allowing to move next step to "connect to replica"
where to look to identify the cause
1
vote
1answer
258 views
SQL Always on availability with failover and mixed authentication
I have 2 boxes running SQL Server 2016, and set up using Always On Availability. I have a listener set up to choose which server to talk to in case of a failover, which seems to work fine, except for ...
3
votes
2answers
453 views
In 2-node cluster using failover with Dynamic Quorum, is Witness needed?
I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum.
There is one thing that made me confused: do we really need a Witness in this case?
Since ...
0
votes
0answers
437 views
SQL Server not starting after SQL Server 2016 SP1 CU6
After installing SQL Server 2016 SP1 CU6, AG listener will not start. Error log is filled with 41066 and 41160. Below are some lines from error log.
Error: 41066, Severity: 16, State: 0.
Cannot ...
0
votes
1answer
630 views
SQL Server Standard Edition Failover Cluster Installing Windows Updates
i have a question concerning the installation of sql server updates on a sql server 2012 standard edition failover cluster.
For example a service pack installation. Is it possible to install the ...
0
votes
2answers
926 views
Always on Failback
Does always on supports automatic failback like sql cluster? Since the preferred owners and possible owners are controlled by the AG how can a particular node be set as preferred primary when failback ...
0
votes
1answer
77 views
Automatic failover support on SQL Server having only two servers
We have two servers each one occupied by a dedicated storage. I am looking for the a way to setup these two servers to provide a database on MS SQL Server with automatic fail-over support.
Using ...
0
votes
1answer
461 views
SQL Clustering Preferred Owners
I noticed that in the sql failover clustering under the possible owners none of the nodes has been checked, I have a two node cluster does that mean in the event of failover it will failover to any of ...
0
votes
1answer
56 views
Sql clustering sql server account
Does both the sql cluster nodes needs to use the same service account ? In my environment I saw one one was using a service account and another was using a local account although the sql agent was ...
1
vote
1answer
232 views
SQL server standard 2016 fail over cluster Amazon AWS
I am in the process of migrating to Amazon AWS and need a SQL server high availability solution. The current licence that I have is SQL standard 2016. At this time Amazon does not support shared ...
1
vote
1answer
308 views
Always on Failover Cluster
This is the error message I get on my replica when there is a connection timeout for few seconds with the Primary. Can anyone tell me whats going on and why are the available storage being moved as ...
0
votes
1answer
339 views
Connectivity timeout between cluster nodes
I lose communication between my clusters almost 1 am to 1.30 am and it shows errors like 35206 on primary, 976 on clusters, sometimes the cluster is removed due to lost heartbeat leading to 1135 error ...
0
votes
0answers
363 views
Adding Azure VM as 3rd node to the 2-node On-Premise Windows Server Failover Cluster - Problem
We have 2-node WSFC, which is hosted on-premise in our datacenter
This WSFC is running one clustered role which is SQL Server Availability Group
Node-1: Windows Server 2016 - two subnets - 192.168.7....
0
votes
1answer
423 views
Managing failover for MySQL nodes using HA Proxy
We have an S1<-M1<->M2->S2 setup of MySQL replicated nodes. These are now to be brought to the back-end of an HA Proxy server to split read from writes. We also intend to achieve automatic fail-...
0
votes
1answer
532 views
Postgresql failback without resync the data directory
Im using Master slave streaming replication in PostgreSQL. Repmgr is configured to handle automatic failover.
Once the failover happened I need to make the old master as a slave without doing any ...
