4 votes
Accepted

How to change from "Read-Only" mode to "Standby / Read-Only" mode?

You can go from Standby back to Restoring, but after recovery you can't go back to Restoring without restoring the backups again with norecovery.
David Browne - Microsoft's user avatar
3 votes
Accepted

What will happen when SQL Server log drive is full?

Why it needs to recover in this case? There was an issue undoing a transaction, this leaves the database in an inconsistent state, in fact the database should move to suspect. You can see from the ...
Sean Gallardy's user avatar
3 votes
Accepted

General questions about write ahead logs and recovery

When an application issues a write request: the data is stored in a memory structure called memtable, and persisted to disk by appending the mutation to a commitlog (WAL). Appending to the commitlog ...
Erick Ramirez's user avatar
2 votes

Reading data from data directory

The correct way to work with any database files is through a running instance of [the correct version of] the DBMS that manages those files. Trying to do anything manually with database files is, ...
Phill  W.'s user avatar
  • 8,578
2 votes

Restore SQL Server deleted files (.mdf, .ldf) (no backup)

I mistakenly deleted the database file and then mdf & ldf files also were deleted. Unfortunately, I did not backup any data and can't install any repair program. Could I restore the mdf, ldf files?...
J.D.'s user avatar
  • 37.2k
2 votes
Accepted

Why does (In Recovery) indication show up?

When you start SQL Server, what is called "recovery" is performed for each database. This basically consist of three steps: Analysis Redo (make sure that operations done for the data but ...
Tibor Karaszi's user avatar
2 votes
Accepted

How to reinstall MariaDB with an old data directory

I presume, from your description, you're on Windows. Install 11.0 using all defaults Then: Stop service (net stop mariadb) change datadir entry in C:\Program Files\MariaDB 11.0\my.ini to point to ...
Vladislav Vaintroub's user avatar
1 vote
Accepted

Is it safe to wipe out pgsql_tmp while the database is not running?

It is absolutely safe to delete all files in the pgsql_tmp of any tablespace (base being the default tablespace). The question is whether manually deleting the files will be slower than PostgreSQL ...
Laurenz Albe's user avatar
  • 50.6k
1 vote

How is the current sequence number in the control file used during recovery?

Perhaps a start on your journey to discovering this: From the Oracle FAQs: Every redo log file has both a log sequence number and low and high SCN. Having said that, why do you feel you need to know ...
Phill  W.'s user avatar
  • 8,578
1 vote

Why does (In Recovery) indication show up?

You can also change the target recovery time of the database or CHECKPOINT the database before shutdown.
David Browne - Microsoft's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible