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
1answer
17 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 ...
-2
votes
0answers
36 views

Assuming SAN data is fault tolerant, is FCI the only SQL technology to replicate entire sql server (instance level HA DR)?

By replicate entire sql server I mean: Databases Logins Jobs And absolutely every other aspect of sql server. The only SQL technology to achieve this, assuming fault tolerant SAN, is failover ...
1
vote
1answer
40 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?
-1
votes
1answer
16 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
votes
0answers
29 views

Is SQL failover clustering the only solution that doesnt require dba to syncronize logins, jobs etc amongst each server?

I am exploring ha dr solutions: Log shipping Mirroring Replication FCI AG Amongst all, only FCI doesn't require dba to sync the logins and jobs amongst all servers (obviously because serves share the ...
0
votes
3answers
55 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 ...
0
votes
2answers
34 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 ...
1
vote
2answers
43 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 ...
0
votes
2answers
67 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 ...
0
votes
0answers
81 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 ...
0
votes
0answers
39 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 ...
0
votes
1answer
44 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 ...
1
vote
1answer
180 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 ...
0
votes
0answers
11 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
55 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
183 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
54 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
903 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
160 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
988 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
445 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
47 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
97 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 ...
1
vote
0answers
32 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
95 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
79 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
235 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
20 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
votes
3answers
204 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
vote
1answer
196 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
27 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
483 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
90 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
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 ...
0
votes
2answers
370 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
389 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
375 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
117 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
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 ...
6
votes
1answer
9k 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
890 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
588 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 ...
4
votes
1answer
261 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
946 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
129 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
62 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 ...
7
votes
3answers
6k 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
999 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 ...