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

💡 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)

Further Reading

Control Transaction Durability | Microsoft Docs