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.
152
questions
0
votes
0answers
9 views
always-on availability group readable secondary disconnected
I have AOAG that hosts many remote sites ( more than 10 each has its own databases) databases, in a centralized data center the customer required if one site disconnected from that centralized ...
0
votes
1answer
52 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 ...
0
votes
1answer
69 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 ...
0
votes
0answers
37 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 ...
0
votes
1answer
405 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
1answer
35 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
...
0
votes
1answer
81 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 ...
1
vote
2answers
590 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 (...
0
votes
1answer
233 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 ...
0
votes
1answer
39 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 ...
0
votes
2answers
54 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 ...
0
votes
0answers
30 views
SQL DR Availability Group cluster validation failure
I'm new to DBA out of necessity at work so please explain or point me in the right resources if you see anything I ask below is wrong:
I'm trying to setup a test environment for Disaster Recovery ...
1
vote
0answers
27 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 ...
0
votes
1answer
59 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 ...
0
votes
1answer
58 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 ...
0
votes
1answer
143 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 ...
1
vote
1answer
16 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 ...
-2
votes
3answers
188 views
How to maintain a Database with stored procedure that runs forever?
I have an interesting question and I cannot find a reply.
I would like to create a database of prime numbers. On this page Prime numbers in a given range , I can find various examples of SQL code ...
1
vote
1answer
117 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 ...
0
votes
1answer
25 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 ...
1
vote
1answer
323 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 ...
1
vote
1answer
60 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 ...
7
votes
2answers
1k 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 ...
0
votes
2answers
305 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 ...
0
votes
1answer
309 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
1answer
231 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 ...
2
votes
1answer
108 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 ...
1
vote
2answers
1k 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 ...
6
votes
1answer
8k 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 ...
0
votes
1answer
818 views
Recover a mongo database deleted by rm
My developer accidentally lost our database by a bash script, which turned out to run rm -rf /* (see this thread). Thanks to extundelete, he just recovered the /data/db/ folder:
However, he could not ...
0
votes
2answers
372 views
I am trying to achieve a Disaster recovery for Mongo DB
Right now i have a MongoDb HA in site one and i need another site with asynchronous replication enables in another location.This is a base plan of mine to achieve a disaster recovery .
I dont have ...
3
votes
1answer
241 views
Attach ldf more current than mdf
Is it possible to create a database where the ldf is more current then the mdf? Or to attach the older (more mature) ldf to the younger mdf (less mature)?
I am working on Steve Stedman's Week 3 ...
0
votes
1answer
26 views
Domain Controller on Multi Subnet Always on Availability Group
This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
8
votes
1answer
634 views
PostgreSQL ANALYZE execution time over 24h (still running)
I upgraded a Postgres DB 9.3.2-->10.5 using pg_upgrade (in place). I did everything according to the documentation and the instructions given by pg_upgrade. Everything went fine but then I realized ...
2
votes
1answer
119 views
Need help with SQL Server 2014 and disaster recovery
I am tasked with building a highly available SQL Server 2014 Enterprise environment for our new policy admin system. This database will eventually grow to 1TB +.
Background
Our normal method of ...
1
vote
1answer
61 views
Standard process during a disaster [closed]
In our environment we have a 2-node Failover cluster instance and log shipping for disaster recovery. Failover cluster is the primary site and log shipping is on DR. 2 node: same data center; log ship ...
6
votes
3answers
5k views
Is there a way to back up agent jobs?
I can't find documentation about whether agent jobs in SQL Server can be backed up. If not, how can I back them up in order to restore during the future recovery in case of an instance failure?
1
vote
1answer
905 views
Quorom Configuration for 3 Node Windows cluster
We have 2 node onsite and the 3rd node on DR and there is no disk witness. Due to maintenance I set the DR site to be primary and the other 2 nodes to be manual in asynchronous mode and after both ...
1
vote
1answer
1k 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 ...
1
vote
1answer
193 views
Problems of having DR as Synchronous Commit
In our always on set up we have One Primary and One Secondary as Synchronous Commit and the DR as asynchronous commit. If i want to change the DR to Synchronous Commit will there be any performance ...
0
votes
1answer
36 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
1answer
769 views
MariaDB master-slave replication failover and failback
I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication.
I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
0
votes
1answer
188 views
Recover Mysql data from formated hard disk [closed]
One of my machine got crashed last day and i ended up reinstalling windows on that machine. It had a mysql server in it. Is there a way to recover mysql data from that machine now . There are couple ...
1
vote
1answer
58 views
Restore MySQL tables with data folder only?
I have many MySQL databases with many tables and I’m trying to figure out if I can restore all of it only using the content of my MySQL data folder.
Or should I just not bother and use the following ...
0
votes
1answer
1k views
Log Shipping Monitor Server Instance
We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every few hours.
...
1
vote
1answer
1k views
Log Shipping Backup and Destination Folder Location [closed]
We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every four hours.
...
3
votes
1answer
345 views
SQL Snapshot Redirect
Company is implementing Database Mirroring Asynchronous with Snapshot. This provides some Disaster Recovery with Reporting area. Server A Principal contains database which mirrors to Server B, ...
1
vote
1answer
450 views
SQL Mirroring Locking/Blocking Contention
We want to setup Mirroring High Performance Asynchronous. Server A Principal contains database which mirrors to ServerB. Mirroring does not allow read-queries unless snapshot is created.
1) If we ...
3
votes
1answer
4k views
Always On FCI vs Always On Availability Groups
What is the advantage of Always On Failover Clustering vs Always On Availability Groups?
Basic Always On Failover Clustering provides server level protection, (eg: 2 servers with 1 shared disk space; ...
1
vote
1answer
224 views
Failover Cluster, Availability Group, and Disaster Recovery
We have an active/passive Windows Failover Cluster setup as an HA solution. Here is an example of what that might look like:
Cluster1: [Node1 'active', Node2 'passive']
We're looking to set up a DR ...
