[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2007-08-02
4
Medium Priority
?
209 Views
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>

thanks
0
Comment
Question by:mshox1
  • 3
4 Comments
 
LVL 14

Assisted Solution

by:NBSO_ISS
NBSO_ISS earned 2000 total points
ID: 19622273
Looks like it could be a hardware issue...

http://support.microsoft.com/kb/828339
0
 
LVL 14

Assisted Solution

by:NBSO_ISS
NBSO_ISS earned 2000 total points
ID: 19622279
Or system problems in SQL Server.  There are some resolution ideas in the link...
0
 

Author Comment

by:mshox1
ID: 19622407
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

thanks

mshox1
0
 
LVL 14

Accepted Solution

by:
NBSO_ISS earned 2000 total points
ID: 19623921
Try running DBCC CHECKDB on the database in question.

http://msdn2.microsoft.com/en-us/library/ms188796.aspx

Listed in the link are also DBCC repair procedures.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

830 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