Database scoped default online options is in preview for Azure SQL DB
This post is authored byJosh Gnanayutham, Program Manager, Azure SQL Database.
We are happy to announce that database scoped default options for online and resumable are now available for public preview. With this feature, you can set a default behavior for online and resumable rather than defining the option for each individual statement.
You can also avoid accidentally performing an operation that takes your database offline. By setting online as the default for your database, you can ensure that every supported operation will be elevated to online. You can override these set defaults by defining an option for online or resumable in the statement.
Users can set these defaults using the ELEVATE_ONLINE and ELEVATE_RESUMABLE database scoped configuration options. Both options will cause the engine to automatically elevate supported operations to online or resumable execution. You can enable the following behaviors using these options:
- You can set either option to FAIL_UNSUPPORTED if you would like to execute all operations online or resumable and fail operations that are not supported for online or resumable.
- You can set either option to WHEN_SUPPPORTED if you would like to execute supported operations online or resumable and run unsupported operations offline or nonresumable. You can set either option to OFF to maintain the current behavior of executing all operations offline and nonresumable unless explicitly specified in the statement.
Behavior of options:
|Supported Operation||Unsupported Operation|
|FAIL_UNSUPPORTED||Execute Online/Resumable||Operation will fail|
|WHEN_SUPPPORTED||Execute Online/Resumable||Execute Offline/Nonresumable|
|OFF||Execute Offline/Nonresumable||Execute Offline/Nonresumable|
For more information about Online operations please review the following documents: