SQL Server Backup has an option to do the sql server database consistency check , see following:

You got errors indicated the potential problems in your database and should be corrected immediately , the problem may be caused by many reasons , this product can only let you know the DBCC check is failed , to get more detail information , you can run the DBCC command once again in Query Analyzer or Management Studio . The command format is :
DBCC CHECKDB ('your database name')
For more detail information about this command , please see the ms sql documentations.