Restore - Database Consistency Check

Do database consistency check after restore :   Checks the allocation and structural integrity of the newly restored database.

• Do not check indexes .
  Specifies that nonclustered indexes for nonsystem tables should not be checked. this option decreases the overall execution time because it does not check nonclustered indexes for user-defined tables , and it has no effect on system tables .
  
• Check only the physical ...
  Limits the checking to the integrity of the physical structure of the page and record headers, and to the consistency between the pages' object ID and index ID and the allocation structures. This option for MS SQL Server 2000 or later.