Questions tagged [recovery]

Reconstructing a database.

Filter by
Sorted by
Tagged with
51
votes
3answers
83k views

How do I get back some deleted records?

I mistakenly deleted around 2,000,000 records from a remote SQL Server 2008 table. The server is not granting me access to the backup files on the server side. Is there any way to get back these ...
39
votes
1answer
71k views

SIMPLE or FULL recovery model for databases?

When should I use the full recovery model and when should I use the simple recovery model for databases? I always used the full recovery model because it is the default, but today i encountered this ...
25
votes
1answer
2k 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 ...
24
votes
3answers
168k views

SQL Server shows database in recovery

Today, after a power failure, one database (with Recovery: full) shows "In Recovery" in SSMS. So: myDatabase (In recovery) (database status: recovery, Shutdown) After finish, the "recovery ...
21
votes
2answers
62k views

Rebuilding the transaction log

We have a very large database (~6TB), whose transaction log file was deleted (while SQL Server was shut down. We have tried: Detaching and reattaching the database; and Undeleting the transaction log ...
15
votes
1answer
54k views

Recover MySQL database from data folder without ibdata1 from ibd files

My WAMP directory accidentally get deleted by another user. Only data folder in MySQLis available. And, in that only database-folders (folders in "\bin\mysql\mysql5.6.12\data\" with name of databases) ...
14
votes
1answer
37k views

Database 'MyDb' is being recovered. Waiting until recovery is finished

I got so error: Database 'MyDb' is being recovered. Waiting until recovery is finished. I have had a critical operation at that time. What is the cause of this situation? And how can it be ...
14
votes
5answers
18k views

Why is Mongo stuck in STARTUP2?

I have a Mongo replica set with a few secondaries. A box, which hosts a secondary instance, crashed and lost the database. I started the secondary Mongo instance again and now it's stuck in STARTUP2 ...
13
votes
2answers
1k views

Online page restore hitting 1000 limit

I've been tasked to try to recover a database which suffered from corruption (due to I/O failure, which has been fixed since). I'm not familiar with the database or what it contains. I've been given ...
13
votes
3answers
24k views

Availability Group database stuck in Not Synchronizing / Recovery Pending mode

While upgrading the storage in a SQL Server 2014 SP1 (12.0.4422.0) instance we ran in to an issue where two of the databases would not start on the secondary after restarting SQL Server. The server ...
11
votes
2answers
5k views

Contents of transaction log file in more detail

I have a question regarding transaction log (let’s just call it LDF for short) contents. I am assuming a database with full recovery model. I have read that LDF file contains (logs) each and every ...
11
votes
2answers
6k views

Restore bak file to smaller mdf and ldf database files

I have a legacy database whose nightmarish lack of design I will not get into here, but the files on the server are (relatively) enormous. I have: MyDatabase.mdf: 24.8GB MyDatabase.ldf: 114.6GB This ...
10
votes
3answers
55k views

Restoring MySQL Tables from .ibd, .frm and mysqllogbin files

For some reason, when I try to open up my tables that are stored in .frm and .ibd files (whether on MySQL or phpmyadmin) it gives me a syntax error, or it says it does not exist. I've read the other ...
9
votes
2answers
3k views

What is an orphan incarnation?

Incarnations are explained in an answer to another question on this site. The answer mentions 'orphaned' incarnations: …There are other factors that result in ORPHANED incarnations and OBSOLETE ...
9
votes
3answers
19k views

Transaction Log maintenance when switching to Simple Recovery

Background: I recently inherited 50+ SQL Servers with 450+ databases. The nightly backups are roughly 8TB and, needless to say, we're using more disk space than we'd like. All of the databases are ...
9
votes
1answer
18k views

How can I recover data from the LDF file?

We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records. We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
9
votes
1answer
2k views

Unable to restore (error 3456)

I have a situation that is not easy to figure out, and thought I'd ask on this forum if others might have suggestions. I'm running SQL Server 2008 R2 Standard SP3 on Windows Server 2008R2 Enterprise. ...
9
votes
1answer
49k views

Postgres is stuck in recovery mode

I have a stand-alone instance of PostgreSQL which is in recovery mode. It has been saying 2014-03-24 18:45:57 MDT FATAL: the database system is starting up For many hours, and ps shows: postgres ...
9
votes
2answers
1k views

PostgreSQL PITR restore

I have a PostgreSQL 9.1 server running on a CentOS 5.8 32bit OS and I have enabled WAL archiving. On this server, there are three databases: databaseA, databaseB and databaseC. Someone deletes a ...
8
votes
2answers
39k views

How can extract the table schema from just the .frm file?

I have extracted the data directory of mysql from a backup and need to get the schema from an old table, however it's a backup from a different machine. I have read a fair number of tutorials today ...
8
votes
1answer
4k views

Can I recover a SQL database from Standby/Read-Only without a standby file?

Is there any way to recover a SQL database from Standby/Read-Only mode if the "standby file" is missing? (I see some references calling this a TUF file in a log-shipping scenario, but in my case, it ...
8
votes
1answer
520 views

Database Stuck 'In Recovery' with command XTP_DB_RECOVERY

We recently converted a table to memory optimized data. Our backups have all ballooned (3x300GB files to 3x600GB files for Full, 3x50GB to 3x250GB for Diffs), and startup has been getting ...
7
votes
2answers
1k views

Two Different Sources Taking Transaction Log Backups

I have inherited a database server with SQL Server 2005. The databases have full recovery mode with hourly transaction log backups. There are two sources taking full backups overnight and hourly ...
7
votes
1answer
541 views

Is it possible to restore SQL Server DB from transaction log (no MDF)?

We had a SQL Server 2005 server that housed roughly 200 low/no traffic archive databases, and that server was not backed up to any other device. The database files (MDF and LDF) were stored on a RAID ...
7
votes
1answer
6k views

Why does database recovery take so long?

On my SQL Server 2012 x64 Std instance I had a large transaction fail due to the transaction log filling up yesterday, it couldn't be rolled back and SQL Server has restarted the specific DB to ...
7
votes
2answers
165 views

Accidental DBA: Unsure why I have a broken log chain?

First of all, thanks for having a look at this - We've got a large database in our production environment (1.26 TB), it's got a few hundred corrupt pages in it and has done for months, so the same ...
7
votes
1answer
6k views

Database msdb stuck in recovery

I encountered a problem while testing recovering backups (Veritas BackUp Exec 2015, just for you to know). Main Problem is: I couldnt restore the databases - looking on the target Server where I want ...
6
votes
2answers
6k views

Recover accidentally deleted rows from a table

My client has accidentally deleted all the records of a table from a test database. This test database is in SQL Server 2005 Express and we don't have a backup. Is it possible to restore the deleted ...
6
votes
3answers
571 views

Is it possible to recover day's worth of queries from sql server log file?

I lost all data entered and edited in my system yesterday, and my ISP has announced to me that last night's backup is corrupt and cannot be recovered. Is there any way to access the database's log ...
6
votes
2answers
17k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
6
votes
3answers
27k views

How to repair, or drop/create a corrupted table in mysql?

Situation: I have a MySQL database with 104 tables, running locally on XAMPP on windows 7. All the tables have InnoDB engine. XAMPP MySQL is running as windows service. As front end I have PHP (...
6
votes
1answer
12k views

How to output more than 4000 characters in sqlcmd

I've made a stored procedure restoredatabase that returns code to restore a database. The output script looks like this: restore database [DB] from disk='F:\FULL1.bak' with norecovery restore ...
6
votes
1answer
13k views

InnoDB log sequence number is in the future

130711 23:03:40 InnoDB: Error: page 23 log sequence number 3336825872455 InnoDB: is in the future! Current system log sequence number 235089. InnoDB: Your database may be corrupt or you may have ...
6
votes
1answer
4k views

Trying to solve “outside tablespace bounds” MySQL error, but recovering table with mysqldump fails

I am running MySQL on a Windows 2008 server. One of the tables (> 1 million records) seems to be corrupted. The mysql error log shows this: InnoDB: Error: trying to access page number 197105 in space ...
6
votes
3answers
2k views

Update old database with SQL dump

I had to recover a database with a some months old full backup. I have however in my possession a most recent but unfortunately incomplete SQL dump for this same database done with mysqldump. Is ...
6
votes
1answer
787 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
5
votes
5answers
539 views

Is there a way to reduce the amount of time spent on a point in time recovery?

I'm pretty sure I know the answer to this, but the limitations of a point in time recovery blows my mind. Say I have a 2TB database set to FULL recovery mode. I diligently take weekly full backups, ...
5
votes
4answers
336 views

Does it make sense to use full recovery if the data and log files are on the same HD?

We have a database that was set up to use full recovery and my guess is that the reasoning was only to prevent data loss if a failure happened between full backups. We make daily full backups of the ...
5
votes
2answers
5k views

Restore database to point in time from full backup only

I have a database with recovery mode set to FULL. It's a dev database and I have two full backups dated 19th and 27th i.e. latest. One of the developer did some changes on 26th and I want to rollback ...
5
votes
1answer
279 views

Electricity off while shrinking database, how can I recover my database?

While i execute shrink database, the electricity has been gone down, I can't access my database now, it is (In Recovery), how can i recover it?? Note: it is a very huge database: 25 GB. EDIT: My ...
5
votes
2answers
17k views

How to recover MariaDB Galera Cluster after full crash?

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others ...
5
votes
2answers
45k views

RMAN list archivelogs that are needed for to recover specified backup

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed. Now, I want to determine what archivelogs should I backup to be sure that my ...
5
votes
1answer
12k views

How to recover/restore corrupted Innodb data files?

A while ago, my Windows 7 system on which a MySQL Server 5.5.31 was running crashed and corrupted the InnoDB database. The weekly backup that's available does not cover all the tables that were ...
5
votes
2answers
484 views

SQL Server 2008 R2 database is suspect, tried it all. Final destination?

This night my hosting provider made a "hard reset" on my VPS hosted in their farm. And one of most important databases (SQL Server 2008R2 database) is now in Suspect mode. My provider has backups (...
5
votes
2answers
15k views

Rollback Committed transaction in SQL Server

Is it possible to rollback a committed transaction? I have deleted all the data in a table. The delete statement is inside Begin Transaction and I have committed the transaction with a commit ...
5
votes
1answer
16k views

The InnoDB log sequence number is in the future

Our site was getting intermittent database errors and I asked my webhost to check what's happening. After some inspection they found that the database has few issues and tried repairing it. Finally I ...
5
votes
3answers
25k views

ERROR Cannot find or open table?

MySQL version: 5.5.24 Due to the following problem: mysql> desc reportingdb.v3_zone_date_cpm7k; ERROR 1146 (42S02): Table 'reportingdb.v3_zone_date_cpm7k' doesn't exist /var/log/mysqld....
5
votes
4answers
7k views

What is a good way to verify that a restore completed successfully in SQL Server?

Right now, we test our SQL backups once a month by pulling the most recent backup file and restoring it onto a test database. If SQL Server says the restore is successful, we spot-check a few tables ...
5
votes
2answers
6k views

Switch from full to simple recovery

This is a theoretical question to help my understanding. What is the process to switch from full to simple recovery model in sql server? Is the process as follows: Take a trans log backup before ...
5
votes
1answer
1k views

Differential/T-Log LSN question

So, this is now my third question on this topic. I just keep finding more and more than i want to know and understand about how FULL recovery works. We transitioned a database to FULL yesterday by ...

1
2 3 4 5
8