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.
173
questions
1
vote
0
answers
25
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 ...
- 111
0
votes
1
answer
28
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 (...
- 33
1
vote
1
answer
90
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 ...
- 111
0
votes
1
answer
49
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 ...
-2
votes
1
answer
87
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 ...
- 2,872
2
votes
1
answer
84
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 ...
- 759
0
votes
2
answers
49
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 ...
- 1,007
2
votes
0
answers
21
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 ...
- 167
0
votes
1
answer
67
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 ...
0
votes
1
answer
169
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 ...
- 1,007
2
votes
1
answer
136
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 ...
- 23
2
votes
1
answer
114
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:...
- 550
0
votes
1
answer
42
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 ...
Jayakrishnan
0
votes
1
answer
101
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?
- 2,872
-1
votes
1
answer
34
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 ...
- 2,872
0
votes
3
answers
69
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 ...
- 2,872
0
votes
2
answers
45
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 ...
- 2,872
1
vote
2
answers
90
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 ...
- 2,872
0
votes
2
answers
262
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 ...
- 1
0
votes
0
answers
265
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 ...
- 231
0
votes
0
answers
70
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 ...
- 2,872
0
votes
1
answer
51
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 ...
- 340
3
votes
1
answer
2k
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
...
- 276
0
votes
1
answer
61
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 ...
- 63
0
votes
1
answer
384
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 ...
- 270
0
votes
0
answers
151
views
Mysql trying to drop table and how to recover data?
I have on lamp setup where suddenly I see all the database files are missing and gone and when I checked the error logs I can see few of this lines.
InnoDB: Error: table `com`.`#sql` does not exist in ...
- 187
1
vote
1
answer
2k
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 ...
-1
votes
1
answer
38
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
...
- 11
0
votes
1
answer
351
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 ...
- 101
1
vote
2
answers
1k
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 (...
- 45
0
votes
1
answer
777
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 ...
- 202
0
votes
1
answer
63
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 ...
- 11
0
votes
2
answers
217
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 ...
- 11
1
vote
0
answers
37
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 ...
- 11
0
votes
1
answer
184
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 ...
- 327
0
votes
1
answer
115
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 ...
- 11
1
vote
1
answer
603
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 ...
- 11
1
vote
1
answer
25
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 ...
- 1,600
-1
votes
3
answers
234
views
How to maintain a query that runs forever?
I would like to run a query that finds prime numbers, and I would like to run it forever.
@Solomon Rutzky on this page Prime numbers in a given range , give us a good example of the Sieve of ...
- 1,165
1
vote
1
answer
305
views
MySQL database backup plan
I have a MySQL database that is about 17GB in size. Right now we don't have a backup for this and I have been tasked to look into backing it up automatically.
I am a software developer myself, not an ...
- 13
0
votes
1
answer
32
views
Disaster Recovery through cloning drives in sql server 2014 enterprise
I am a DBA noob and recently my work has considered to have a disaster recovery plan for their production DB lets say A (sql server 2014 enterprise). The production server A and Disaster recovery ...
- 13
1
vote
1
answer
796
views
Is it safe to restart PostgreSQL if process terminated for some reason?
I am writing a docker-compose config with a container with PostgreSQL in it. docker-compose has a configuration options called restart. If I enable it then whenever the Postgres process stops it will ...
- 151
1
vote
1
answer
131
views
Log Shipping between 2 AGs
I'm having one AG with two nodes (active-passive) in one data center and another AG with two nodes (active-passive) in a different data center.
I need to have log shipping enabled between these two ...
- 11
7
votes
2
answers
2k
views
What is the best option for High availability on a data warehouse?
I have a customer who have an existing 1.5Tb data warehouse and are currently planning for a complete refresh of the DW on a new environment. Their infrastructure manager has organised 2 servers with ...
- 71
0
votes
2
answers
487
views
Transaction Replication as DR solution
I have a production database server and a failover database server set up.
All the transactions from the primary production db server is being replicated(transactional replication with initialize ...
- 1,295
0
votes
1
answer
534
views
How to setup a SQL Cluster between 2 sites in active passive mode without shared storage
we need to install SQL at 2 sites, 1 primary and 1 DR. We don't to pay for license for the DR and need to know how will we setup a SQL cluster/replication/alwayson/bag or any other method that will ...
-1
votes
1
answer
693
views
Accidentally overwrote mysql database with empty data [closed]
I accidently imported an empty database backup file into the same database, using mysql-workbench. Is there any way to undo this and get the data back? The backup available is 4 months old which is ...
- 107
2
votes
1
answer
145
views
What are the potential issues after data or log disk failure?
Scenario:
A client recently had an issue with an Azure VM where the (non-OS) 'premium' storage disks were erroneous removed without warning by Microsoft. This is the virtual equivalent to the hard ...
- 145
1
vote
2
answers
2k
views
Always On Availability Group Failover Issue
I'm testing a PowerShell Disaster Recovery script and trying to fail over to an off-site AG DR (asynch) replica with this command
ALTER AVAILABILITY GROUP [MyAG] FORCE_FAILOVER_ALLOW_DATA_LOSS
On ...
- 186
6
votes
1
answer
11k
views
Restore mongoDB by --repair and WiredTiger
We accidentally deleted the directory rm -rf /data/db
which was our MongoDB path, and thanks to
extundelete, we recovered it and got the directory /data/db.
Here are our files in the directory, and ...
- 61