question

Mehdi593 avatar image
Mehdi593 asked

Drop Table

after execute drop table Tbl Attempt to fetch logical page (1:570112) in database 7 failed. It belongs to allocation unit 72057611494686720 not to 281474980642816. when execute checkdb A severe error occurred on the current command. The results, if any, should be discarded.
drop
18 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Have you considered copying all the objects out of your database into another database (excluding the table you want to drop)
2 Likes 2 ·
Do you have a backup that you can restore? If so you may be able to drop the affected table and recover it from your backup
0 Likes 0 ·
thanks for your answer. i restore backup and try drop table but get this error: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:57481; actual 0:0). It occurred during a read of page (1:57481) in database ID 26 at offset 0x0000001c112000 in file 'D:\SP_Databases\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\wss_pbc_content_hermes.mdf:MSSQL_DBCC26'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
0 Likes 0 ·
so do you have a backup where the table isn't damaged?
0 Likes 0 ·
No, i Have not.
0 Likes 0 ·
Show more comments

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.