SQL data base corrupt, can not even 'drop table'.  but can run bcp "out" to dump the data.

Posted on 2007-08-02
Last Modified: 2013-11-05
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>

Question by:mshox1
    LVL 14

    Assisted Solution

    Looks like it could be a hardware issue...
    LVL 14

    Assisted Solution

    Or system problems in SQL Server.  There are some resolution ideas in the link...

    Author Comment

    How can I 'drop' the table, I know it is 'bad'?   the SQL database is not responding.  - get time out.

    If I can drop it, I can recreate it with empty row then I can reload the data.

    Please help


    LVL 14

    Accepted Solution

    Try running DBCC CHECKDB on the database in question.

    Listed in the link are also DBCC repair procedures.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now