x

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.

more ▼

asked Feb 10 at 01:47 PM in Default

avatar image

Mehdi593
11 1 5

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

Feb 12 at 07:40 AM Kev Riley ♦♦

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.

Feb 12 at 08:19 AM Mehdi593

so do you have a backup where the table isn't damaged?

Feb 12 at 08:31 AM Kev Riley ♦♦

No, i Have not.

Feb 12 at 08:51 AM Mehdi593

Have you considered copying all the objects out of your database into another database (excluding the table you want to drop)

Feb 12 at 01:51 PM Kev Riley ♦♦
show all comments (comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x16

asked: Feb 10 at 01:47 PM

Seen: 71 times

Last Updated: Feb 13 at 01:15 PM

Copyright 2018 Redgate Software. Privacy Policy