[SQL server 6.5 sp3 NT 4 sp3]
When I try to drop a corrupt table I get this message:
"Error 1117: [SQL Server] Extent chain for object 111827028 is not
Is ther a other way to drop the table?
Thanks in advance...
Yes but its very messy.
Can you rename the table and truncate/ delete the data from it. You may be
better off just leaving it at that.
The way around this though is
Remove all entries of the table from the system tables.
Run dbcc newalloc - this will tell you that there are space allocated but
Run Dbcc Fixal - This will reclaim the unused space and correct the problem
I would recommend doing a full dbcc check before any of this though and if
there are any other problems it may be better to stick with the rename or
restore from the last backup.
I hope this was of use.
I have a table and one index seems to be corrupt (Production-DB)
("index-id in reservation-page does not correspond to index in sysindexes")
-> DBCC NEWALLOC reports Errors 2541, 2504 and 2543
-> attempts to repair index with DBCC REINDEX or DBCC FIX_AL fail
-> attempts to drop the index or the whole table fail with Error 1117
-> error is also in backup-copy
How can i correct this error ?
Thanks in advance
10. Error 1117
12. Fatal Error 1117