Questions tagged [disaster-recovery]

A set of policies and/or procedures that enable the recovery or continuation of vital infrastructure and systems. Please be sure to include what DBMS you are using.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

Migrate cold database (freebsd) to mariaDb on ubuntu

I have a little bit of a pickle: I have a freebsd based jail that ran nextcloud with mysqldb The machine running the jail is broken. I still have the jail with the data. Now I was wondering if I can ...
chas0r's user avatar
  • 1
0 votes
1 answer
78 views

Does application need to do anything to handle database failover?

I'm trying understand database failover (mainly in SQL Server) and what handling is required from application side to have zero downtime (no failures) to handle DB failover? Assuming that DBAs have ...
Hitesh's user avatar
  • 3
-1 votes
1 answer
34 views

Backup and Restore Disaster Recovery

I am using PowerShell to write a script for DR, assuming that we only have backup files of all the databases. If i have a latest sql server version and i want to restore some database from backup ...
LearningSQL's user avatar
0 votes
0 answers
26 views

Cascading DR - Switchover issue in Oracle

I have 3 databases:A, B, C. A is the primary database, and the log_arhive_dest_2 parameter is set accordingly: log_arhive_dest_2=service='A' ASYNC valid_for=online_logfile,PRIMARY_ROLE B is the ...
datascinalyst's user avatar
-2 votes
2 answers
49 views

Does a DR plan need to be in place for an AlwaysOn availability group

I have two SQL servers 2022 in a normal availability group. I have heard that AG is capable of disaster recovery. Is this true or do I need to make an extra plan? Another question: Why is Failover ...
Hector234's user avatar
0 votes
0 answers
53 views

Postgres - how to manage losing a tablespace

I have a postgres 13 database installed on an SSD drive. 90% of the tables and indexes are in a tablespace on the SSD drive. I also have a 2nd hard disk (magnetic HDD) which contains a 2nd tablespace, ...
ConanTheGerbil's user avatar
0 votes
1 answer
593 views

Mysqld won't start although lower_case_table_names is 0 and match the data dictionnary

I copied a mysql 8.0.26 database from a Linux server to my Windows box but mysqld won't start. Either it's this (with lower_case_table_names=1): [ERROR] [MY-011087] [Server] Different ...
Micromega's user avatar
  • 111
0 votes
2 answers
6k views

SQL Server Connection String - MultiSubnetFailover True or Yes?

The MultiSubnetFailover option in database connection strings controls how the client attempts to connect to a database server, especially when multiple IPs are available. There is conflicting ...
Riley Major's user avatar
  • 1,873
1 vote
0 answers
44 views

DR - Missing binlogs in Maxwell

We have a standard db.r6g.2xlarge RDS MySQL instance running in production with 2 replicas. Maxwell CDC is setup to publish binlogs to a Kafka topic. From a RPO point of view: in the worst case (say ...
Amit Dalal's user avatar
0 votes
2 answers
1k views

SQL1273N - Missing log file "S0000000.LOG" in database partition "0"

I'm getting this error when trying to connect to a DB2 Database. This error started after the OS restarted. db2 => connect to cm SQL1273N An operation that reads the logs in database "CM" ...
PAULO CRISTIANO KLEIN's user avatar
0 votes
1 answer
53 views

How to validate whether the correct SMK has been restored?

Link: https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-service-master-key-transact-sql?view=sql-server-ver16 Assuming during a DR event I am provided with the SMK file, system db files ...
variable's user avatar
  • 3,561
0 votes
1 answer
299 views

Creating a multi-region active-passive DR plan for Aurora MySQL?

I'm trying to create a disaster recovery plan for a cost efficient, maintainable and with little down for Aurora MySQL. I want two read/write databases in two different regions, they can be separate ...
CKT's user avatar
  • 101
2 votes
3 answers
73 views

What is a good way to get a time for the data freshness when the source is log shipped to another server?

I'm log shipping from SERVER_A with backups every 10 minutes. I restore the logs to SERVER_B every 20 minutes. I pause the restores while I do a DWH load from SERVER_B into SERVER_C I report out of ...
Brent Seeney's user avatar
1 vote
0 answers
38 views

Data retrieval from WAL since cluster init

Postgres documentation is very clear that to utilize the WAL archive for replication or restore, a base backup must first be in place, upon which later WAL records can be applied. Firstly, would it be ...
PinnyM's user avatar
  • 111
0 votes
1 answer
168 views

PostgreSQL stops continuous recovery without error

I have some Postgresql 10 instances running on Windows Server that are in continuous recovery mode. Once in a while they just stop recovering without giving any errors, like in this example log file (...
Norba's user avatar
  • 43
1 vote
1 answer
1k views

How to recover Postgresq data from $PGDATA/base files after system crash

I was working on my Ubuntu machine and left it on to grab food. Upon returning, I found it had shut itself down. It was not power failture because I have a home backup system and lights never go off ...
TheRealChx101's user avatar
0 votes
1 answer
97 views

which High Availability and Disaster Recovery method would be suitable for my SQL Express server

What are the considerations that would determine which High Availability and Disaster Recovery method would be suitable for my MSSQL express server? These are some of the considerations I found on the ...
IT Researcher143's user avatar
-2 votes
1 answer
245 views

What is the general recommendation for sql server crash recovery from mdf/ldf vs backups for least data loss? [closed]

I'm learning steps to recover from sql server OS or OS disk crash. Assuming the OS or OS disk is corrupted and unrecoverable. I know that a HA solution like fci or ag is better suited to prevent such ...
variable's user avatar
  • 3,561
1 vote
1 answer
314 views

Database stuck in a read only state when testing a DR scenario with a multi-subnet SQL Server Always On AG, how can I get the db in a healthy state?

I am testing a disaster recovery scenario with azure VMs. I have sql servers deployed across 2 regions joined together via Always On availability groups sitting on top of a multi-subnet WSFC. When I ...
Eric Swiggum's user avatar
0 votes
2 answers
264 views

Failing over to DR site Availability group

I have a 4 node cluster SQL 2012 availability group database with one witness server at the primary site. 3 nodes are in the primary site and one node in the DR site. Due to maintenance at the Primary ...
SQL_NoExpert's user avatar
  • 1,049
2 votes
0 answers
34 views

Why would my MySQL replica server experience an sql integrity constraint error after losing connection and attempting to start again?

I have a master-master replication setup between two different servers using MariaDB. One is the primary server (server A) that is connected to my web applications, and the other is a replica that ...
Timothy Fisher's user avatar
0 votes
1 answer
134 views

Sql server replication for HA and DR

1.)According to brent ozar's HA and DR chart,for Failover Cluster Instance - SQL Server minimum version supported and SQL Server minimum edition required is given as 'any'. Does that mean it works ...
IT Researcher143's user avatar
0 votes
1 answer
463 views

File Share Witness location

We have a 4 node availability group with 3 node on the primary data center and one node on the secondary data center. We want to add a file share witness and since we dont have a third data center and ...
SQL_NoExpert's user avatar
  • 1,049
2 votes
1 answer
300 views

What is the correct configuration for the SQL Server listener with 2 nodes on-prem and 1 node in Azure?

I am setting up a 3-node Availability Group with 2 nodes on-premises and the 3rd on a VM in Azure. All nodes are SQL Server 2019 Enterprise with CU14. The Availability Group is fine and the listener ...
Kevin Feit's user avatar
2 votes
1 answer
321 views

Availability groups across sites: what happens if severs can't contact each other but both still can reach file share witness?

I'm currently planning a new SQL Server 2019 Enterprise Edition setup with HA/DR, possibly with availability groups. Let say we have the following setup: Site A: one SQL Server instance (SQL1) Site B:...
Eric Prévost's user avatar
0 votes
1 answer
54 views

AlwaysOn availability group listener

There is a server with me that is already configured with AlwaysOn by somebody else. I am adding one more availability group to the server. Can I use the same availability group listener for the new ...
user avatar
0 votes
1 answer
768 views

What is the reason to backup master, msdb and model system databases? [duplicate]

What is the reason to backup master, msdb and model system databases? How does it help during disaster recovery? And are they to be restored just like user databases?
variable's user avatar
  • 3,561
-1 votes
1 answer
75 views

What is the equivalent of on prem ha dr solutions in the azure cloud PaaS and SaaS?

On prem ha dr solutions are: Log shipping Mirroring Replication FCI AG What is the equivalent of each of the above in the azure cloud PaaS (azure sql managed instance) and SaaS (azure sql ...
variable's user avatar
  • 3,561
0 votes
3 answers
199 views

Is there any sql ha dr solution that allows write to multiple servers?

I am looking for a sql ha dr solution that allows users to write to multiple replicas. Is this possible in sql server? For example: AG allows read from multiple replicas. But write only to primary ...
variable's user avatar
  • 3,561
0 votes
2 answers
124 views

Do I need to be carefull about log shipping log backups truncating tlog?

We have full backups running every Sunday. Differential every day. Log backups every hour. This is all configured as part of our recovery strategy. I have been requested to configure log shipping on ...
variable's user avatar
  • 3,561
1 vote
2 answers
402 views

What is the advantage of full backup over snapshot backup when it comes to restore by applying tlog?

What is the difference between following restore options: A. Full backup and applying to it subsequent log backups. B. Snapshot backup and applying to it subsequent log backups. Note: this is not ...
variable's user avatar
  • 3,561
0 votes
2 answers
660 views

Connect two Percona XtraDB Clusters in two data centers

I have been trying to figure this out the past couple of weeks. We used to have a five-host Percona cluster at different providers. When it started acting up I read that it is a bad idea to have ...
Les's user avatar
  • 1
0 votes
0 answers
489 views

Deleted Postgresql Data Directory

PostgreSQL data directory was accidentally deleted. Right know I'm using photorec to recover all the files in the disk. I also know from the docs the structure of that directory. There are text files ...
cachique's user avatar
  • 231
0 votes
0 answers
171 views

Why is FCI not considered to be a DR solution? [duplicate]

FCI is said to be an HA solution. If one node crashes, it spins up the 2nd node so why is it said to not be a DR solution? There was a disaster at node 1 and node 2 picked up from there. Isn't that ...
variable's user avatar
  • 3,561
0 votes
1 answer
68 views

HA options for a VLDB

We have 2 VLDB's - 6TB (primary db, not much OLTP traffic) and 4TB (archive db). Data will be moved/archived (delete from primary and insert to archive) daily from 5 large tables. Currently this ...
Kris's user avatar
  • 422
4 votes
1 answer
7k views

How do I recover data from the postgres data directory on my hard drive?

I had an old iMac which stopped working a while ago I take weekly backups of the database I was updating which contains feed items from several rss feeds I am still missing the data for the last week ...
PirateApp's user avatar
  • 296
0 votes
1 answer
67 views

Log files in Always on Disaster Recovery Situation

In my Always on Avaliability group setup there are four nodes in the cluster in two datacenters, an avaliability group has for replicas, one on each node. Two replicas in the same datacenter have sync ...
Garry's user avatar
  • 73
0 votes
2 answers
736 views

How to ensure backups are successfully persisted to S3 when using Ola Hallengren solution on AWS EC2 Instances

Improving Existing Backup Approach By Using Ola Hallengren Backup Solution Deploying a new backup approach to eliminate dependency on a vendor tool (Cloudberry) that I've leveraged before. In my ...
sheldonhull's user avatar
1 vote
1 answer
3k views

Corruption of files in postgres: The database subdirectory "base/13067" is missing

Right, my PostgreSQL database 11.1 is on top of a GlusterFS. My GlusterFS break, my backup was being done on another table and I don't have backups anymore. I started the database on a docker ...
Psycho Mantys's user avatar
-1 votes
1 answer
39 views

SQL alwayson AG Disaster Recovery

Need advise on below: I have 2 node alwayson AG on Primary Sync mode in the current configuration and fsw is in Primary DC only Actually during Switchover the entire DC 2 node and fsw will be down ...
mukki's user avatar
  • 11
0 votes
1 answer
727 views

PostgreSQL WAL Archival Best Practices?

The postgresql documentation gives an example archive_command of archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' # Unix but adds the disclaimer ...
bpaterni's user avatar
  • 101
1 vote
2 answers
2k views

AlwaysOn availability group DR failover with Powershell

I am setting up AlwaysOn availability group for Disaster Recovery (DR) in the test environment. For AG1, node1 and node2 (synchronous commit/automatic failover) are in DC1; node 3 and node 4 (...
AMMH's user avatar
  • 45
0 votes
1 answer
2k views

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

Our database structure utilizes two roles in the Window Failover Cluster Manager. One is for FCI - switching between the active/passive node in the Primary Data center. One is for SQL Availability ...
Fylix's user avatar
  • 202
0 votes
1 answer
80 views

SQL server Log Shipping

I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can ...
mukki's user avatar
  • 11
0 votes
2 answers
423 views

SQL server alwayson 3 Node Primary Down

I am using three node alwayson Availability Group SQL 2012 Enterprise Edition. 2 Node in DC with File Share Witness quorum also in DC and third node to be setup in DR I need to perform a DR switchover ...
mukki's user avatar
  • 11
1 vote
0 answers
75 views

Splitting file groups of large SQL Server database using FileStream

Background: I have a SQL Server database which is storing documents in the file stream. These documents are usually accessed via Web API by Mobile Apps and Modern JS Apps. The size of the database ...
Angry Coder's user avatar
0 votes
1 answer
268 views

SSD used for tablespace died. How can I recover data?

I have a postgres cluster with two databases Database A uses the default tablespace. It holds important information but has very few writes per day (< 20) and only has a few tables with a few ...
sheepdog's user avatar
  • 345
0 votes
1 answer
217 views

Why distributed AG is preferred to normal AG for cross datacenter failover scenario?

I have two node WSFC and currently I'm working on DR solution with availability group.I already read microsoft doc about distributed AG.So my question is what are benefits of using distributed AG ...
hg1735's user avatar
  • 11
1 vote
1 answer
2k views

Why do I need witness in WSFC with two nodes?

I have Windows Server 2019 and SQL Server 2019 running in both nodes of my cluster. In my case everything is working fine without witness. I need Windows Server Failover Clustering (WSFC) for ...
hg1735's user avatar
  • 11
1 vote
1 answer
28 views

Database Mirroring - Will forcing the service only lose non-committed data?

I have a database mirroring session in high safety mode between Server1 (Primary) and Server2 (Secondary) According to this, synchronous data mirroring means every transaction committed on the ...
SE1986's user avatar
  • 1,960