Monday, October 24, 2011

Repair SharePoint Database

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>

Example,

image

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

image

Post a Comment