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.