Simple Database Recovery Model

The database recovery model controls how transactions are logged and whether log backups are possible. In most cases, a production database should have regular log backups, requiring the FULL or BULK-LOGGED recovery model.

Suggested Action

šŸ’” Aireforge Advisor can automatically generate a script for this.

Consider whether this database should have its recovery model changed to FULL or BULK-LOGGED.

How to Change the Database Recovery Model in SQL Server

USE [master]
GO
ALTER DATABASE [WhippetWorks] SET RECOVERY FULL WITH NO_WAIT
GO

Further Reading

Recovery Models (SQL Server) | Microsoft Docs