Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: failover

Would SQL Server in a Cluster failover if it is running out of RAM

By adminPosted on March 4, 2023

Question : I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running […]

Shouldn’t Windows Server Failover Clustering already take care of SQLServer Failover Clustering?

By adminPosted on February 27, 2023

Question : After reading this question, Are “Always On Failover Cluster Instances” and “SQL Server Failover Clustering” the same thing? […]

How do I switch master with slave and vice versa on MySQL?

By adminPosted on February 20, 2023

Question : I have two instances of MySQL, one master and one slave. How can I switch them to make […]

How to optimize and estimate DB recovery times?

By adminPosted on February 8, 2023

Question : Would like to optimize recovery time for db’s after failover to passive node in high availability cluster. Assuming […]

Why automatic failover does not occur when I turn off SQL Service in SQL Server Failover Cluster Instance?

By adminPosted on February 7, 2023

Question : I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case […]

Repmgr : It automatically promotes to new master but other standby stopped

By adminPosted on February 4, 2023

Question : I’m trying to setup postgre with repmgr and here is the rsult The scenario is, i tried to […]

Does this plan work as a Failover strategy-SQL Server 2016 Standard Edition

By adminPosted on January 29, 2023

Question : We have two SQL Server 2016 Standard edition (standard edition due to budget issues) configured one as primary […]

Good practices for patching SQL nodes in High Availability solution [duplicate]

By adminPosted on January 25, 2023

Question : This question already has answers here: patching SQL Server with Availability Group and Secondary Replica (4 answers) Closed […]

Manual sql failover machine with replication

By adminPosted on December 31, 2022

Question : I hope this is the correct place to ask this question. We recently experienced one of our virtual […]

Stopping SQL Services on Active Node [closed]

By adminPosted on December 28, 2022

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

  • 1
  • 2
  • 3
  • …
  • 16

Recent Posts

  • How can I create a gapless sequence?
  • Unable to Query Very Large Table
  • Why should I create an ID column when I can use others as key fields? [duplicate]
  • Force NOW to return new timestamps without committing the transaction
  • MariaDB on Windows Server 2012 R2 – out of memory
  • How to easily convert a comma seperated list of ids into a table of rows
  • clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
  • Slow MySQL query
  • Database design : hotel room and its detail
  • How to use GROUP BY in an efficient way without losing attributes? [closed]
  • Query execution time is random, need to identify the root cause
  • Returning data where all categories exactly match
  • Partitioning increases CPU usage in mariadb
  • How to script out push subscription creation at the subscriber?
  • Can a transitive join loop infinitely?
  • 2 similar queries in large sql server table – 1 takes too long
  • Select data from another database instance on the same server in sql server
  • Is it possible to get server roles and database roles in a same query/script?
  • UPDATE performance where no data changes
  • Can I parse a text value from a specific column in a query (MySQL)?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding