Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sulaiman
Starting Member
7 Posts |
 Posted - 2008-05-17 : 07:46:25
|
| Dear All,i made full-text index on one table.while i run a query using Contains clause the following error occurs,Server: Msg 7619, Level 16, State 1, Line 1The content index is corrupt. How can solve this Problem without down the Sql Server 2000, this is happend me very frequently. once i restart the System ,it would be okay.THanksM A Sulaiman |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 17:52:03
|
| Did you see disk problem in windows event log? |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-05-17 : 19:04:35
|
| Yup - likely to be IO subsystem issues causing the corruption. Does the database itself reside on the same storage? If so, is it corrupt too? How often do you run DBCC CHECKDB on your database?ThanksPaul RandalSQL Server MVP, Managing Director, SQLskills.com |
|
|
|
sulaiman
Starting Member
7 Posts |
Posted - 2008-05-18 : 01:52:38
|
quote:
Originally posted by rmiao
Did you see disk problem in windows event log?
yes,i checked windows event log , i didn't find any errorthanks |
|
|
|
sulaiman
Starting Member
7 Posts |
Posted - 2008-05-18 : 01:54:13
|
| i run checkdb weekly.thanksM A Sulaiman |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-18 : 21:15:01
|
| Any error from dbcc? Another thing I'll try is recreate full text catalog on fast disk. |
|
|
|
sulaiman
Starting Member
7 Posts |
Posted - 2008-05-19 : 02:53:05
|
| I did n't find any errorsthanksM A Sulaiman |
|
|
|
|
|
|
iNDEX cORRUPT