Hi. I received 3 content Databases and one of the databases has a site collection that is apparently corrupt. Someone may have tried to delete the site collection and maybe it didn't delete all the way or who knows. I need to be able to delete the site collection and move the other site collections in that DB. There are 26 of them. However when attempting to do anything with any of the site collections in that DB I get HResult Errors. When I click on the site collection in Central Administration, it's listed but none of the details are displayed. Here are some actions I tried to perform: When you click on the site collection in Central Admin, nothing gets displayedWhen you try and delete it, you cantWhen you try and run an stsadm migrateuser command on any person thats associated with the siteID, you cantWhen you try and delete any other site collection in that DB, you cantWhen you run stsadm databaserepair, no orphans show up. I took at look at the data in the content DB and the site id seems to flow properly all through the tables. It's listed in the Sitemap in the config DB as well as the sites and web tables. When I try to run a command such as migrateuser on a user who's associated with that siteid in the userinfo table I get "There is no Web named "/sites/Sitename". I can clearly see it though in the webs table! I've been looking at this now for 3 days and I'm stumped. Anyone have any ideas? I'm running SharePoint 2007 Office server with the August 2010 CU Patch. Sql 2008 R2 is the backend.

Is this site in production? If not (or if you can schedule a maintenance window), try detaching and reattaching the content database. This may force SharePoint to sort out some of these internal consistencies. Also, when you say you received these databases, what do you mean? Did someone send these to you from another farm? Please clarify. Jason Warren Infrastructure Architect Habanero Consulting Group habaneroconsulting.com/blog

Is this site in production? If not (or if you can schedule a maintenance window), try detaching and reattaching the content database. This may force SharePoint to sort out some of these internal consistencies. Also, when you say you received these databases, what do you mean? Did someone send these to you from another farm? Please clarify. Jason Warren Infrastructure Architect Habanero Consulting Group habaneroconsulting.com/blog