Database Integrity Check Has Never Run or Overdue

DBCC CHECKDB checks the logical and physical integrity of all objects with a SQL Server database, providing an early warning of data corruption.

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Run DBCC CHECKDB and implement a routine check.

How to Perform a Database Integrity Check in SQL Server

--Run the check for the current database
DBCC CHECKDB;

--Run the check against a specified database, suppressing all informational messages
DBCC CHECKDB('WhippetWorks')WITH NO_INFOMSGS;
GO

Further Reading

​DBCC CHECKDB (Transact-SQL) | Microsoft Docs

​SQL Server Integrity Check | SQL Server Maintenance Solution