Warning: Fatal error 7987

We are seeing this problem in our application:

Warning: Fatal error 7987 occurred at Apr 10 2006 9:18AM猠楡⹤䄠牰汩椠⁳敤楳湧瑡摥愠⁳慎楴湯. Note the error and time, and contact your system administrator.

And upon checking the SQL logs we are seeing everytime a specific simple query is run:
A possible database consistency problem has been detected on database 'allscoopdb'.  DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'allscoopdb'..

We had this problem once last week, and a reboot fixed it.  The error is coming up everytime we run a specific sql query against the allscoopdb database.  We have been running this query for over a year with no problems.

I've run the DBCC CHECKDB and it has returned no errors.  Do you think there could be some kind of hardware problem?  Or what else can I do to figure out what the problem is?  

We are running MSSQL 2k on a big box.  It's a quad box with 16 gigs of RAM with a SAN device.  We are using managed hosting at RackSpace.

Help!
customscoopAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

imran_fastCommented:
<< The error is coming up everytime we run a specific sql query against the allscoopdb database. >>
run this statemnt

DBCC CHECKCATALOG ('allscoopdb')
GO

DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO




imran_fastCommented:
This problem migth be because of bad sector in the disk so try running scan disk for windows at a drive containing log file and datafile for the allscoopdb database.
customscoopAuthor Commented:
Those look great.  Will running either:

DBCC CHECKCATALOG ('allscoopdb')
GO

DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO

Require single user mode, making the database unavailable in anyway?
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

imran_fastCommented:
did u run this
DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
customscoopAuthor Commented:
Here is the error I've gotten from the DBCC CHECKDB:

There are 69159732 rows in 280572 pages for object 'KeywordMatches'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'KeywordMatches' (object ID 693577509).

When I run this:
select keywordid from keywordmatches WITH (INDEX (keywordmatches11))
forcing it to use that index, it blows up.  So I suspect this index is having problems.  It did take 6 hours to run so I'll give the REPAIR_FAST option a try overnight.  I'll update this in the morning.

imran_fastCommented:
<< 2 consistency errors in table 'KeywordMatches' (object ID 693577509).>>
Try dbcc dbreindex(KeywordMatches') with All_indexes
customscoopAuthor Commented:
Thanks!  The DBCC CHECKDB ('allscoopdb', REPAIR_FAST) fixed all my problems!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.