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
Last activity: Apr 12, 2024, 07:17 AM