Sharepoint 3.0 / SQL Errors filling SQL log

MS Windows 2003 Server SP2
Member server
WSS 3.0

We are having disk space issues on our sharepoint server as the SQL error log in constantly filling up. The errors in event viewer are:

EVENT ID 10027
Failed to update committed transaction in SQL, DocID is 5983.

Context: Application 'Search index file on the search server', Catalog 'Search'

      One or more errors occurred during processing of command.   (0x80040e14)

For more information, see Help and Support Center at

EVENT ID 10036
 database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 8630 occurred 1 time(s)
Description: Internal Query Processor Error: The query processor encountered an unexpected error during execution.

Context: Application 'Search index file on the search server'

Any ideas of the cause?

Who is Participating?
Auric1983Connect With a Mentor Commented:
Looks to me like it's the indexing service in sharepoint trying to crawl some file shares...  Check the index service in Sharepoint central admin
YellowbusTeamAuthor Commented:
This is the directory that is filling up with sql errors and sql dumps:


YellowbusTeamAuthor Commented:

Where should i be looking to find the Index Service?

we are also recieving a large amount of .mdmp files in the folder of SharePoint SQL, which in our case is the:

This is in turn making the C drive fill up and then the server crashes, are all these things related to the same issues?

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Auric1983Connect With a Mentor Commented:
On the sharepoint server, in the central administration site.
YellowbusTeamAuthor Commented:

Thanks for that.
We have stopped and then started the Search Service, then created a new database for the serches to use. This in turn has stopped the error from being produced in the event viewer.

Thanks for your Help
Auric1983Connect With a Mentor Commented:
Excellent - You'll want to double check the search crawling settings to make sure the search credentials are correct etc.  

Search for "Sharepoint search service config" on google and you'll find help for that.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.