Simple Database Recovery Model Detected
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.
💡 Select 'Suggested Script' for an automatically generated script.
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
Recovery Models (SQL Server) | Microsoft Docs