Sample Header Ad - 728x90

How to fix table with corrupt rows

1 vote
1 answer
1154 views
I was inserting records into a table, when I suddenly got disconnected from the DB server When I tried doing a row count on the table, I got a fatal error 824 I tried DBCC CHECKTABLE and it indicated that the table had consistency errors, and recommended repair_allow_data_loss The table has 49021 rows, and I can still select the 49013 rows and accessing the rows beyond that yields to the fatal error 824 The records I was trying to insert into the table are not very important, and are just test data. I was wondering if it would be safe to perform repair_allow_data_loss in that matter? Or is there any workaround in removing the corrupted rows from the table? We have a backup table, and I was wondering if doing a truncate on the table and inserting the data from the backup table will work?
Asked by jambajuice
Jun 22, 2023, 11:04 AM
Last activity: Apr 12, 2024, 07:17 AM