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>



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


1 comment:

Adam Gorge said...

The stsadm utility works only when you have updated backup. In case if you have no backup then you can try for Third party SharePoint Repair Tool to repair corrupt SharePoint Database.