The inbuilt utility call DBCC CHECKDB checkout the logical and physical consistencies of the SQL database key elements like pages, index, tables etc. Sometimes this command fails because of the high corruption level as well as chances to loss data. So in such sutations must use SQL database recovery software which recovers intact SQL database MDF file, NDF Files with its core elements Must & read try the demo from here
http://www.sqlrepairtool.org