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.
Suggested Action
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)
Further Reading
Control Transaction Durability | Microsoft Docs