Orphaned sites in MOSS 2007

There has been issues related to orphaned items present in the sharepoint sites. Inorder to detect and delete the orphaned items follow the commands as mentioned below...

Detect an orphan site


To detect orphaned items, use the following syntax:

stsadm -o databaserepair -url http://sharepointsite/ -databasename [name of DB where orphaned site is present]

Delete an orphan site

To delete orphaned items, use the following syntax:

stsadm -o databaserepair -url http://sharepointsite/  -databasename [name of DB where orphaned site is present] -deletecorruption

For more reference on this http://technet.microsoft.com/en-us/library/cc263282.aspx

Hope this helps someone...