Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Question Unanswered: Corrupt Database?

    We have a table (> 4,000,000 rows) that appears to be missing data, but if we copy the table using "insert into new_table from bad_table" some of the missing data mysteriously reappears. I am assuming there is something wrong with the database, but I don't know where to begin. Can anyone give me some idea of what might be wrong? Thanks in advance!

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Make a fresh backup and use DBCC.

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Thanks, it turned out to be a corrupted index. We dropped and rebuilt the indexes and all the "missing" records reappeared!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •