Timeline for Corrupted database. How to restore it from an old backup and add newer changes after?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 30, 2022 at 23:19 | comment | added | Charlieface |
@charade sys.syscolpars is a system table, which you can only access via a DAC connection. It's unlikely that it will allow an index rebuild (these tables are normally read-only) but you could try. DBCC should not crash the server whatever the issue is, if it is doing so then report a bug.
|
|
| Mar 30, 2022 at 13:07 | comment | added | charade | Thanks for your answer! I have some doubts: - How can I rebuild the index? I haven't found any documentation about these tables and I don't understand what they do. They are 16 consistency errors in total, so it might be feasible to do. - How do I restore "All log backups"? Do they refer to the transactions being done in the database? - I've tried already checkdb with repair_allow_data_loss and repair_rebuild. It detects the 16 consistency errors, but then there is a crash of MSSQL CHECKDB with EXCEPTION_ACCESS_VIOLATION and process is terminated | |
| Mar 30, 2022 at 11:01 | history | edited | Shanky | CC BY-SA 4.0 |
added 23 characters in body
|
| Mar 30, 2022 at 10:54 | history | answered | Shanky | CC BY-SA 4.0 |