sometimes you may encountered with problems such as restoring failures and content deployment failures thus it is better to repair the database and see where is there any orphan objects in the site collection.
For that go to SharePoint Management Shell as an administrator,
use following command
stsadm -o databaserepair -url <url name> -databasename <database name>
here no Orphaned Objects found if they are listed run the command with deletecorruption option.
stsadm -o databaserepair -url <url name> -databasename <database name> -deletecorruption