Accelerated database recovery (ADR)

Accelerated database recovery, or ADR, is a new database recovery process that greatly increases availability and decreases database recovery time in scenarios such as crash recovery (database recovery in the event of a server/database crash) and long-running transaction rollback (for example, a large bulk insert or an index rebuild rollback).

An SQL database consists of data and a transaction log file. A data file contains the table data. A transaction log file keeps track of all the changes made to the data and the schema; for example, if there is an insert in a table, the transaction log file contains the insert statement and whether the insert statement was committed or not.

The standard database recovery process

To better understand ADR, let's first get an understanding of the standard database recovery process:

Figure 9.7: The recovery phase without ADR

Note

Image taken from https://docs.microsoft...