Error message:
Event ID 9511 from Source Office Server Search on agent computer xxx.domain.com has triggered this Alert Description : Errors occurred during database operation, please make sure the SQL server is running and there is sufficient disk space available on the database drives.
Context: Application 'SharedServices1', Catalog 'Portal_Content'
Symptom:
index crawling is hang , can check at the search admin at SSP ( crawl log is not moving and stuck for many hour after DB problem)
Solution :
make sure DB server is back online and do recycling search service below :
Recycle Services
The crawl portion of search is a state machine and components sometimes get out of sync. Because the state of the crawl is stored in the Search databases, the search processes can be recycled. When restarted, these will simply regain state from the DB. Also, as noted above, there are cases where provisioning components may get hung up, so recycling the Timer and Administration service could also help:
- From services.msc on each of the Query Servers, recycle the following services:
- Office Server Search
- Windows SharePoint Timer
-
From services.msc on the Indexer, then recycle:
- Office Server Search
- Windows SharePoint Services Administration
- Windows SharePoint Services Timer
more information : http://blogs.msdn.com/b/sharepoint_strategery/archive/2012/09/10/troubleshooting-the-ssp-search-indexer-for-moss-2007.aspx
