Using Accelerated Database Recovery to Keep Azure SQL Database Logs Under Control
Learn how to enable Accelerated Database Recovery (ADR) in Azure SQL Database to speed up recovery and prevent log growth caused by long-running transactions.
Loading…
ReadMeFeed / Community knowledge
#accelerated-database-recovery
Real questions. Useful conversations. Find the people who know your stack.
azuresqldatabaseADR Does Not Reverse Committed Schema Changes in Azure SQL Database
Accelerated Database Recovery (ADR) in Azure SQL Database is documented to shorten rollback and crash recovery through a persisted version store. While most DDL is transactional and an uncommitted ALTER TABLE can be reversed with ROLLBACK TRANSACTION, ADR does not make a committed schema change undoable. After a COMMIT TRANSACTION, reversal requires a databa