Validating the Database After You Restore

To ensure that tapes have been restored in the correct order, you should run the stored procedure sp_iqcheckdb after you finish restoring your database.

If you are restoring a set of incremental backups, it is safest to run sp_iqcheckdb after restoring each backup. To save time, however, you may prefer to run sp_iqcheckdb only after restoring the last incremental.