0

SQL Server 2019 CTP introduced a new feature – accelerated database recovery. But then something strange started to happen:

  • If we look at doc page about this feature, we would see no mention of SQL Server 2019 – there’s Azure DB only.
  • If we look at sys.databases description, we would see no mention of is_accelerated_database_recovery_on column, while in fact, it exists
  • Same thing about accelerated_database_recovery database option.
  • However, feature matrix shows ADR available for Standard and Enterprise SQL Server editions.

On the one hand, enabling ADR could benefit with faster transaction rollback and lesser startup time.

On the other hand, feature seems undocumented. Therefore, it’s behavior is unpredictable. If something goes wrong with transaction log, I could literally lose some data.

So, does anybody knows: can I rely on ADR using SQL Server 2019? Is it postponed due to some instability or it is just a glitch in documentation?

4

The documentation page link in your question is specific to Azure SQL Database. Note Azure in the url:

https://docs.microsoft.com/en-US/azure/sql-database/sql-database-accelerated-database-recovery.

The Accelerated database recovery page in the general documentation shows ADR is included in SQL 2019 and Azure SQL Database.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.