ADR
Accelerated Database Recovery
Accelerated Database Recovery
Enable
ADR can be enabled per-database in SQL2019 and aboveEnable
ALTER DATABASE [mydb] SET ACCELERATED_DATABASE_RECOVERY = ON;Â
Disable
Disable
ALTER DATABASE [mydb] SET ACCELERATED_DATABASE_RECOVERY = OFF;
GO
Bibliography
Bibliography
https://learn.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-conceptshttps://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-and-recovery-overview-sql-serverhttps://learn.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-troubleshoot