Skip to main content

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
26 votes
1 answer
4k views

PostgreSQL DELETE FROM fails with `Error: attempted to delete invisible tuple`

The error Trying to delete tuples containing invalid timestamps with DELETE FROM comments WHERE date > '1 Jan 9999' OR date < '1 Jan 2000' OR date_found > '1 Jan 9999' OR date_found < '1 ...
Kai's user avatar
  • 781
10 votes
3 answers
21k views

What to do when your Always On cluster loses quorum?

I was reviewing our company DR procedures and when I looked online for solutions to an Always On Cluster losing quorum, to compare to. I was three pages into google results before finding the first ...
James Jenkins's user avatar
10 votes
3 answers
8k views

Can I recover a TDE certificate by restoring the MASTER database?

(We are, fortunately, not currently in this situation, just planning ahead to see what our options would be if it ever occurred.) For a database encrypted with Transparent Date Encryption (TDE), a ...
BradC's user avatar
  • 10k
9 votes
1 answer
5k 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 ...
wjozsi's user avatar
  • 171
8 votes
3 answers
15k views

Why is Full Recovery model a requirement for an Availability Group?

We have all our production databases in simple recovery model, and are very happy about it because it fully satisfies our RPOs and RTOs. Now we want to implement AG DR solution for our databases and ...
Bit Cat's user avatar
  • 97
8 votes
2 answers
5k views

Broken tempdb location and can't recover

Made a mistake and mistyped an alter database command for tempdb. Now the instance won't start. I can't start in single user mode using -m as it states the tempdb could not be found. I tried using: ...
user avatar
8 votes
2 answers
3k 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 ...
Nick Baker's user avatar
7 votes
3 answers
13k 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?
igelr's user avatar
  • 2,132
7 votes
3 answers
2k views

Recommended mirroring alternative?

SETUP 2 Amazon EC2 SQL 2014 servers in different availability regions. Synchronous mirroring S3 for archiving full backups & logs at night Right now for simplicity, nightly full compressed ...
sheldonhull's user avatar
7 votes
1 answer
13k 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 ...
国贵棠's user avatar
6 votes
2 answers
2k views

SQL Server 2012 Standard Edition Disaster Recovery Options?

Suggest me the best method for My DR plan. Currently we have set of databases (6) used for our application and we in the process of building DR and HA plan. As we are into small business we are using ...
Ajay's user avatar
  • 61
6 votes
1 answer
2k views

SQL Server rollback schema update

Say I have a hand-written script which performs a bunch of schema changes, eg: (plucked from air): Adds 2 columns to an existing table Creates a new stored procedure Alters an existing stored ...
Alex McMillan's user avatar
6 votes
3 answers
2k views

SQL Server Always On Node and File Share Majority

I am looking for some guidance on architecting our SQL Server 2016 SP1 Always On Availability Groups HADR solution on Windows Server 2012 R2. We have a primary site A with a primary replica and a ...
Mike Petrak's user avatar
5 votes
1 answer
8k 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
  • 306
5 votes
1 answer
53 views

Recover Instance after Log File disk error

This is mainly theoretical, but I would like to have a documented list of options if this happens in the future. Today we had a critical disk error on the SAN, meaning the disk holding the ...
Molenpad's user avatar
  • 1,784
5 votes
3 answers
2k views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
goorj's user avatar
  • 258
4 votes
1 answer
340 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 ...
James Jenkins's user avatar
4 votes
1 answer
224 views

New SQL Server from backup; application has successful login on 1 database, but fails on another: 0x80040e4d

Our SQL Server crashed and burned, the hard drives destroyed. No hope of recovery. We need to get a very important application working again; this is on a different server. We've set up a new SQL ...
Levi's user avatar
  • 360
4 votes
2 answers
13k views

FATAL: catalog is missing 1 attribute(s) for relid 2662

I have a server with PostgreSQL9.1-903 (Windows 7 Professional). After a power cut my database is inaccessible (I presume that the database is corrupted). The postgreSQL service starts but the ...
Oscar's user avatar
  • 41
4 votes
2 answers
3k views

SQL Server DR Plan - Test Documentation

I have been tasked with creating a document for the testing of our DR/BC Plan for our SQL Servers. We are using DB Mirroring (tier-1) and transaction log shipping (tier-2) and for tier-3 databases we ...
Lima's user avatar
  • 161
4 votes
1 answer
7k views

How to restore corrupted InnoDB tables?

We have a data loss: the MySQL database is dropped and we have to restore the tables from ibd files. The backup is too old so we have to undelete the deleted database files. Most of the tables are ...
Dániel Kis's user avatar
4 votes
1 answer
19k views

Not receiving archivelogs from production to remote side [closed]

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...
M.AZ's user avatar
  • 69
3 votes
1 answer
8k 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; ...
user avatar
3 votes
1 answer
481 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, ...
user avatar
3 votes
1 answer
574 views

Can you restore log file backups to a mirror database after failure?

Purely a theoretical question as I've been considering possible DR scenarios... In this scenario: The link between a principle and a mirror server becomes unavailable for a period of time (e.g. ...
paulH's user avatar
  • 1,444
3 votes
1 answer
1k views

Archivelog file deleted, resulting in 'ORA-01113: file 1 needs media recovery'

(This is not a production database. I'm practicing in a staging enviroment.) I'm trying to set up RMAN for backup/recovery. I did a full backup, which seems to be in a good state. I then did an ...
aioobe's user avatar
  • 155
3 votes
1 answer
1k views

v$ or rc views to report on RMAN restore database preview

Setup: We take an Incremental level 0 backup weekly using: RMAN> backup as compressed backupset incremental level 0 database; RMAN> backup check logical as compressed backupset (archivelog all ...
Kris Johnston's user avatar
3 votes
2 answers
690 views

SQL Backup/Restore and Disaster Recovery solutions with VMware

Is vSphere Replication safe for SQL databases? We are a virtual environment (Cisco hardware + VMware hosts + HP san). We have a primary and disaster recovery datacenter, with SAN-level replication ...
d-_-b's user avatar
  • 1,154
3 votes
1 answer
702 views

Log Shipping Fails with CONTINUE_AFTER_ERROR

DR plan for primary database in a private hosted cloud environment. The primary is a hosted physical server. The secondary is on another network, same domain. Version is SQL Server 2008R2 (10.50.2550....
Graeme's user avatar
  • 135
3 votes
0 answers
494 views

Recovery from Live to a new Slave Server - PostgreSQL - ERROR

I've started a new SLAVE PostgreSQL server set up. master: 192.168.100.1 slave1: 192.168.100.2 slave2(NEW SLAVE) 192.168.100.3 * NOTE: I run the pg_basebackup from another STANDBY SERVER. Not from ...
Lucas's user avatar
  • 31
3 votes
1 answer
1k views

Log shipping - failed over to secondary, how to fail back

SQL 2012 I've been researching and testing Log Shipping as a DR solution. I got the two servers setup. Log shipping is in place and verified to be working correctly. I failed over by restoring the ...
SQLChao's user avatar
  • 403
2 votes
3 answers
77 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
2 votes
1 answer
716 views

Disk Crashed, NDF(Index) file lost

I have database with : -two filegroups (PRIMARY and INDEX) -three files .mdf(data), .ndf(index) and .ldf(log) every file is on different disk, yesterday disk where was NDF file crashed so I lost ...
Cubone's user avatar
  • 23
2 votes
1 answer
5k views

SQL Server AlwaysOn Error:35250

I am configuring AlwaysOn in my test environment but getting the following error. Msg 35250, Level 16, State 7, Line 1 The connection to the primary replica is not active. The command cannot be ...
Vinesh Senthilvel's user avatar
2 votes
1 answer
321 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
360 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
2 votes
1 answer
4k views

MySQL: Recover Master from Slave after failover

I have replication running between two MySQL instances on two separate servers. Let's say M is the master and S is the slave. It's setup as one way replication M->S. I currently have S as read only ...
postelrich's user avatar
2 votes
2 answers
706 views

Get missed transactions from slave

I'm trying to write a disaster recovery plan, I have one way replication with 1 master(A) and 3 slaves(B,C,D) A /|\ / | \ B C D Let's say my master crash, and I loose all data on ...
altmannmarcelo's user avatar
2 votes
1 answer
138 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 ...
John L.'s user avatar
  • 29
2 votes
1 answer
52 views

AAG expansion between datacenters

We have a 2 node AAG setup in the DC data center, and due to an application requirement, it requires a third node to be created at the DR site and the only option I have is at the Data center in San ...
buddinggeek's user avatar
2 votes
1 answer
2k views

How to recover an overwritten SQL Server database

We have SQL Server Standard Edition with several databases. We backup via a Windows Task that executes the sp_BackupDatabases procedure. We have a case where a database got replaced by a backup from ...
NPadrutt's user avatar
  • 121
2 votes
3 answers
837 views

Problem to access the SQL Server

I have SQL Server 2005 which is installed on server machine. I was working fine on SQL server before I change the server machine IP. I changed server machine IP to host the Web Service on it. But ...
Charan Ghate's user avatar
2 votes
1 answer
173 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 ...
Andrew Hanlon's user avatar
2 votes
1 answer
890 views

Getting past corrupted binary log "Error in Log_event::read_log_event():"

I have a binary log that mysqlbinlog chokes on with the error in the title. The file itself has much more activity after the cited position. Doing some basic confirmation it's not all garbage by ...
atxdba's user avatar
  • 5,273
2 votes
1 answer
93 views

SQL Server AG in primary site with separate WSFC AG in secondary site

I would like some feedback from those experienced with SQL Server Availability Groups (AGs) in multiple sites. We have a scenario where there are five SQL Server 2012 Enterprise Edition servers in a ...
Darius Liktorius's user avatar
2 votes
5 answers
3k views

Getting Data Back after Wrong Data Restore in SQL Server

I would like to inquire if there is an possible way to return lost data that stored in a Sql server Database after making a wrong database restore? I know it is extremely hard to get a positive ...
Ahmed Elbatt's user avatar
2 votes
1 answer
957 views

Mysql trying to recover from Hard disk failure [duplicate]

Am trying to get a database up and running after having a hard disk crash, got the data recovered. mysql can only start with the innodb_force_recovery set as 5 or 6. When started I can get a table ...
Peter's user avatar
  • 21
2 votes
0 answers
37 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
2 votes
1 answer
99 views

Recover mysql using data folder

One of our MySQL servers died but somehow we were able to recover all the files from it. This server was a slave at one time however we stopped it being a slave so we could use it for housekeeping ...
ajsdg's user avatar
  • 21
2 votes
0 answers
93 views

How To Roll Back DR Transactions Without Breaking Mirror

We have a full data center DR test coming up and will need to fail over all of our SQL Server databases to the DR site. The majority (>80%) of our databases are SQL Server 2008 R2 using Database ...
Michael Brule's user avatar