SQL data base corrupt, can not even 'drop table'. but can run bcp "out" to dump the data.
Posted on 2007-08-02
I have a SQL database that have many tables (10-15), few of the tables have the records 200-500, 000
rows. with cluster index - unique.
Recently, we encountered error code 605 (hard failure) on 1 or 2 of the table (never the same one), we can drop the table, recreate the table, and reload the data. create the index, it will runs well.
We encountered another issues today (error code 823). and when we do an query (any query), the table will get timeout.
I tried to drop the table, it also get the time out.
what I should do?
what are the real root cause of this? do you know any way to prevent it from happen>