Export data from corrupted table

• Benki Chendu

  SSCrazy Eights

  Points: 8051

  More actions

  September 18, 2013 at 1:58 pm

  #277315

  I have a table that has inconsistency errors.

  There are around 13 million rows of data in it.

  1. If I truncate this table and run a dbcc, would the errors disappear?

  2. Is there a way I can copy the latest 1 million or half a million rows of data through export data wizard or through select * into?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 18, 2013 at 2:07 pm

  #1651285

  Benki Chendu (9/18/2013)

  ---

  1. If I truncate this table and run a dbcc, would the errors disappear?

  If the errors are only in that table, yes.

  2. Is there a way I can copy the latest 1 million or half a million rows of data through export data wizard or through select * into?

  Filter by the clustered index key and query in batches. If a query hits the corruption it will fail, so you won't be able to do a select * without a where clause.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Benki Chendu

  SSCrazy Eights

  Points: 8051

  More actions

  September 18, 2013 at 2:20 pm

  #1651290

  Thanks Gail.

  Is there a query for the 2nd point?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 18, 2013 at 2:25 pm

  #1651293

  SELECT <column list> FROM <damaged table> WHERE <clustered index key column> BETWEEN <some lower boundary that works> AND <some upper boundary that works>

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass