Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

188 questions
26
votes
1 answer

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 Jan 2000'; ends in ERROR: attempted to delete invisible…
Kai
  • 781
  • 5
  • 10
10
votes
3 answers

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 copy of the database backup is unrecoverable unless…
BradC
  • 10,073
  • 9
  • 51
  • 89
10
votes
3 answers

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 SE post on the subject Clustering vs.…
James Jenkins
  • 6,318
  • 6
  • 49
  • 88
9
votes
1 answer

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 that the indexes were not being used in one of the…
wjozsi
  • 171
  • 1
  • 6
8
votes
3 answers

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 we found out that full recovery model is a…
Bit Cat
  • 97
  • 1
  • 1
  • 3
8
votes
2 answers

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: net start msqsqlserver /f /t3608 But then I can't…
user20442
8
votes
2 answers

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 SQL 2017 standard on each and has now asked me to…
Nick Baker
  • 81
  • 1
  • 6
7
votes
1 answer

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 the files was generated under MongoDB version…
国贵棠
  • 71
  • 1
  • 1
  • 4
7
votes
3 answers

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
  • 2,162
  • 3
  • 26
  • 56
7
votes
3 answers

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 backups Tran Logs every 15 mins (would do more if can…
sheldonhull
  • 280
  • 2
  • 11
6
votes
1 answer

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 procedure And, after running this, we discover that we…
Alex McMillan
  • 161
  • 1
  • 6
6
votes
3 answers

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 secondary replica and a disaster recovery (DR) site B…
Mike Petrak
  • 436
  • 6
  • 16
6
votes
2 answers

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 standard edition 2012 and we are unable to make…
Ajay
  • 61
  • 4
5
votes
1 answer

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 I currently have the hard drive of the old…
PirateApp
  • 316
  • 4
  • 18
5
votes
1 answer

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 Transaction Log files for one of our production instances…
Molenpad
  • 1,814
  • 2
  • 23
  • 41
1
2 3
…
12 13