Delete orphaned sites or items in sharepoint 2007.

To delete orphaned sites or item from a sharepoint site, we have 2 options.

Option 1.

• Opened a command Prompt and went to this directory: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
• Type following command to list the orphaned sites: stsadm -o databaserepair -url http://URLofWindowsSharePointServicesSite -databasename DatabaseName
• To delete orphaned site :stsadm -o databaserepair -url http://URLofWindowsSharePointServicesSite -databasename DatabaseName -deletecorruption
  The above command might delete orphaned sites and items.

If above steps doesn't resolve orphan issue then apply below mentioned Option 2

Option 2

• Go to command prompt as given in Option 1. Run command stsadm -o deletecontentdb -url http://URLofWindowsSharePointServicesSite -databasename "databasename" (remember database name)
• Now run command stsadm -o addcontentdb -url http://URLofWindowsSharePointServicesSite -databasename "databasename"

I hope option 2 might resolve orphan issue.

Nilesh