Ensuring that your database is consistent

Although BACKUP does check that all necessary files are present before backing up your database, it does not check internal consistency. For a more thorough check, you can run the stored procedure sp_iqcheckdb before making a backup. See “Validating your database” for details.