Administration

Accelerated Database Recovery in SQL Server

Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions.  What Is Database Recovery?  In a previous post, I discussed the SQL Server Restore and Recovery…






Restore and Recovery

The restoration process of a SQL Server database passes through two phases: Restore and Recovery.