Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 How Does SQL Add to Corrupted Table After Corrupt?
 Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

119 Posts

Posted - 01/28/2013 :  09:33:32  Show Profile  Visit davidshq's Homepage
I have a SQL table with millions of rows. It has suffered a corruption which DBCC CHECKDB is unable to repair in any of its many variations. I can view the first several million records, before the corruption hits and a SELECT * FROM table query dies.
What I am wondering is if/how SQL adds additional rows to the table after corruption? Or does it not add additional rows? e.g., now that the corruption has occurred is it adding new rows when requested to the table? If so, is there any way to get all the uncorrupted rows and just drop/truncate the corrupted rows?

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 01/28/2013 :  11:05:14  Show Profile  Visit jackv's Homepage
What exact error message are you getting? What does this give you?DBCC ChecKDB('<my_db>') WITH NO_INFOMSGS, ALL_ERRORMSGS

Do you have a backup?Restore the backup .

Jack Vamvas
Go to Top of Page

Posting Yak Master

212 Posts

Posted - 01/29/2013 :  06:08:09  Show Profile  Visit prett's Homepage
I will suggest you to repair your corrupted tables first before performing any activity on the database. To find the perfect DBCC command, as jackv suggested you first mention the result of this command:

This command clearly will show you "where is the exact problem". & then you can use DBCC CHECKDB according to your need.

Edited by - prett on 01/29/2013 23:14:01
Go to Top of Page


5072 Posts

Posted - 01/29/2013 :  11:24:34  Show Profile  Visit russell's Homepage
No. Do NOT allow DBCC to repair corrupted table(s).

This only DELETES data.

First run the CheckDB as jackv stated, post the results here if u need help interpreting them.
Go to Top of Page

Starting Member

11 Posts

Posted - 03/15/2013 :  06:39:34  Show Profile
Database of MS SQL Server is stored in .MDF file format either on Server or local drive. MDF files get damaged due to slow running of SQL Server, virus codes, accidental deletion of files and other factors. With RecoveryFix for SQL database, you can retrieve user data such as triggers, views, tables, hyperlinks and stored procedures from corrupt MDF files. It recovers SQL database in its original text formatting.

Go to Top of Page

Starting Member

36 Posts

Posted - 05/05/2014 :  00:35:09  Show Profile
Hopefully this will help

Go to Top of Page
  Previous Topic Topic Next Topic  
 Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000