SET DURABILITY
SET DURABILITY {RELAXED | STRICT | DEFAULT}
Access requirements
Database user
Usage
Use the SET DURABILITY statement to set the transaction durability level.
The SET DURABILITY statement takes effect from the next transaction (that is, after the next COMMIT WORK statement).
Parameters, clauses, keywords, and variables
▪ STRICT: A transaction is written to the transaction log as soon as the transaction is committed.
▪ RELAXED: A transaction can wait until the server is less busy, or until multiple transactions can be written to the transaction log together.
▪ DEFAULT: The durability level that is defined by the Logging.DurabilityLevel parameter is used.
Examples
SET DURABILITY STRICT;
Go up to