Removing orphaned site collections from a content database

While deleting a large site collection on the Ver environment the process timed out. This resulted in the site collection being unavailable through a browser but still being listed in the site collection list in Central Admin. However, it was not possible to select the site collection in Central Admin to delete it. Also the command ‘stsadm -enumsites’ reported the following when it came to that site collection:
<Site Error=”The system cannot find the path specified. (Exception from HRESULT: 0x80070003)” />
IISRESET did not fix the problem
The solution was to dettach and reattach the content database from the web application.
Central Admin > Application Mgmt > Content Databases
Select the web application
Open the content database
Make a note of the DB name and the warning and maximum site values
Delete the content database
Add a content database with the values previously recorded
The site collection should no longer be listed in the web application.
Advertisements

One thought on “Removing orphaned site collections from a content database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s