CODEWITHSUNDEEP
sql-server-2019sql-server-2019-express
kbisang
kbisang

Reputation: 576

How to disable the feature Accelerated Database Recovery (ADR) in SQL Server 2019 Express edition?

Is there a way to disable the new feature Accelerated Database Recovery (ADR) in the SQL Server 2019 Express edition?

Upvotes: -3

Views: 1180

Answers (1)

kbisang
kbisang

Reputation: 576

Obviously on SQL Server 2019 Express edition the ADR feature is turned off by default

If I try to turn off the feature as follow

ALTER DATABASE databaseFoo SET ACCELERATED_DATABASE_RECOVERY = OFF;

the answer is:

Commands completed successfully.

If I try to turn on the feature as follow

ALTER DATABASE databaseFoo SET ACCELERATED_DATABASE_RECOVERY = ON;

the answer is:

Msg 12128, Level 16, State 1, Line 3 Accelerated Database Recovery cannot be enabled on Express edition.

Msg 5069, Level 16, State 1, Line 3 ALTER DATABASE statement failed.

Conclusion: Within the article (posted in comment by Larnu) chapter Enabling and controlling ADR the mentioned behavior that ADR is turned off by default in SQL Server 2019 corresponds as well for SQL Server 2019 Express edition.

Upvotes: 0

Related Questions