Delayed Durability Set to Forced
This warning is because the database's delayed durability level has been set to FORCED (default DISABLED), which means that every write transaction is forced to use delayed durability, which could result in data loss.
Using Delayed durability can improve the performance of SQL Server, but it is not recommended to set this at a database level.
⚠ If you cannot tolerate any data loss, you should not use delayed durability on your tables or databases.
💡 Aireforge Advisor can automatically generate a script for this.
If delayed durability is required, consider using ALLOWED and controlling it at a COMMIT level, rather than at a database level.
How to Configure Delayed Durability in SQL Server
USE [master] GO ALTER DATABASE [WhippetWorks] SET DELAYED_DURABILITY = ALLOWED WITH NO_WAIT GO
How to Use Delayed Durability During Transactions
COMMIT TRANSACTION WITH (DELAYED_DURABILITY = ON)
Control Transaction Durability | Microsoft Docs