Run DBCC CHECKDB to Check a SQL Server Database

Classic way to check the database is alright.

DBCC CHECKDB('DatabaseName') WITH NO_INFOMSGS, ALL_ERRORMSGS