A service request has been registered with Microsoft, i will update this thread with progress over time.

GilaMonster (10/4/2011)

---

Mark S. Rasmussen (10/4/2011)

---

Also we have a system table corruption right at the beginning (Msg 8921, Level 16, State 1, Line 1

Check terminated. A failure was detected while collecting...

HowardW (10/4/2011)

---

How did you do the block level restore? Was it from a Windows Server Backup? You wouldn't normally expect this sort of backup to be so totally corrupted...

Is it...

Mark S. Rasmussen (10/4/2011)

---

Restore or IO subsystem glitch (since the log was on a disk that's 'very gone', it's not a stretch to think that there are other IO subsystem...

I chose a table and ran CheckTable:

Msg 824, Level 24, State 2, Line 1

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:8743947; actual 0:0). It occurred during...

Failure in communicating would be the short version. 🙁

GilaMonster (10/4/2011)

---

serr4no (10/4/2011)

---

Thank you:

http://pastebin.com/3auHfWDq%5B/quote%5D

I don't know what that link is supposed to be, and I'm not going to an unknown site for unknown content. Post the results here,...

GilaMonster (10/4/2011)

---

serr4no (10/4/2011)

---

From the error log:

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:8743947; actual 0:0). It occurred during a read of page (1:8743947) in database ID...

Thank you:

http://pastebin.com/3auHfWDq

Database is attached and in emergency mode (was in suspect right after sql-server started up), the tables can be listed but not selected from.

Nothing has been done except dbcc checkdb...

Gianluca Sartori (10/4/2011)

---

serr4no (10/3/2011)

---

Hello guys, im in a bit of a bind:

A partitioned database got wiped and then block-restored (no other backup available), it's now attached but wont go online...

dbcc checkdb('db_name') with estimateonly

returned:

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Is the situation beyond all hope of repair? Any ideas?