| Author |
 Topic  |
|
|
sulaiman
Starting Member
India
7 Posts |
 Posted - 05/17/2008 : 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 1
The 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.
THanks
M A Sulaiman
|
|
|
rmiao
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 05/17/2008 : 17:52:03
|
| Did you see disk problem in windows event log? |
 |
|
|
paulrandal
Yak with Vast SQL Skills
USA
899 Posts |
Posted - 05/17/2008 : 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?
Thanks
Paul Randal
SQL Server MVP, Managing Director, SQLskills.com |
|
|
|
sulaiman
Starting Member
India
7 Posts |
Posted - 05/18/2008 : 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 error
thanks
|
|
|
|
sulaiman
Starting Member
India
7 Posts |
Posted - 05/18/2008 : 01:54:13
|
i run checkdb weekly.
thanks
M A Sulaiman |
|
|
|
rmiao
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 05/18/2008 : 21:15:01
|
| Any error from dbcc? Another thing I'll try is recreate full text catalog on fast disk. |
|
|
|
sulaiman
Starting Member
India
7 Posts |
Posted - 05/19/2008 : 02:53:05
|
I did n't find any errors
thanks
M A Sulaiman
|
|
|
| |
Topic |
|
iNDEX cORRUPT
