The transaction durability level is set with the Logging.DurabilityLevel parameter. The parameter has three different values for durability: relaxed (1), adaptive (2), and strict (3).
Adaptive durability is used only with HotStandby (HSB). If adaptive durability is configured, the actual durability depends on the status of the HSB servers:
▪ If primary and secondary servers are connected and operating normally (in PRIMARY ACTIVE and SECONDARY ACTIVE states), the server uses relaxed durability.
▪ In all other situations (for example, PRIMARY ALONE, STANDALONE), the server uses strict durability.
For an explanation of the differences between strict and relaxed durability, or for more information about the Logging.DurabilityLevel parameter, see Logging section.