Data Purity Checks

The Data Purity setting in SQL Server is an option for the DBCC CHECKDB command. Adding the DATA_PURITY option causes the CHECKDB command to check for column values that are invalid or out of range1. Any database created in SQL Server 2005 or later will include the DATA_PURITY check by default.

Suggested Action

Run DBCC CHECKDB WITH DATA_PURITY.

For databases upgraded from earlier versions of SQL Server, column-value checks aren't enabled by default until DBCC CHECKDB WITH DATA_PURITY has been run error free on the database. After this, DBCC CHECKDB checks column-value integrity by default.

How to Enabled CHECKDB with Data Purity

USE [WhippetWorks];
GO
DBCC CHECKDB WITH DATA_PURITY;

Further Reading

​DBCC CHECKDB (Transact-SQL) | Microsoft Learn

​Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions | Microsoft Learn