One of the improvements included on the Service Pack 2 for MOSS 2007 to make our life more easy is the way to eliminate orphan items in our Content database.
Now, we have to follow these steps to clean up our database:
Run the following stsadm command
Stsadm –o enumallwebs –databasename -databaseserver
It should show a result similar to that:
And then you have to run the deletesite command for all webs where InSiteMap is equal to False:
Stsadm –o deletesite –force –siteid -databaseserver -databasename
On the above example:
Stsadm –o deletesite –force –siteid 14f9385d-f543 –databaseserver myServer –databasename myDB_Content
And anymore steps are needed. However, It seems that enumallwebs command output only locates Content db orphans, not Config db orphans. Which is OK, because Content db orphans are more common and much more difficult to delete. In order to eliminate the Config db orphans, you still need to detach/attach the content db as I explained on “MOSS 2007 and Orphan objects – Part II” post.
Angel Perez Palacios 