Use dbcc checkstorage to perform the following checks:
Allocation of text valued columns
Page allocation and consistency
OAM page entries
An OAM page for each partition exists
Pointer consistency
Text-valued columns and text-column chains
The following syntax is for dbcc checkstorage, where dbname is the name of the target database (the database to be checked):
dbcc checkstorage [(dbname)]
dbcc checkstorage runs checks against the database on disk. If a corruption is only in memory, dbcc checkstorage may not detect the corruption. To ensure consistency between two dbcc checkstorage runs, run checkpoint before running dbcc checkstorage. However, doing so can turn a transient memory corruption into corruption on disk.
