-- Cranfield (12/12/2008)

---

yip. I'll save NYSE the cash.

btw - I was at your Surviving Corruption session at PASS. It was the best session I attended. As you can see...

Most of the frontline support folks know less than many people here...

Not much point - they're not going...

Repairing here would have lost two pages of table data - but I might still have been tempted to restore the backups and see if those two pages were in...

As Gail said, use RESTORE WITH STOPAT to recover your database to the point before the corruption occured (roughly as follows)

1) Restore the full database backup. Use the STOPAT and...

No - because of condition (b) that you specified. If the database is switched to FULL recovery model, but a database backup isn't done, then the database stays in a...

Mazharuddin Ehsan (12/4/2008)

---

Thank you very much Paul for your elaboration. However, I have just one doubt.

Paul Randal 12/4/2008 10:50 AM

-------------------------------------------------------------------

It's not a B-tree (either the classic B-tree, or the...

Not my area of expertise - someone else on the thread will help out I'm sure.

Mazharuddin Ehsan (12/4/2008)

---

Not necessary nazanin. The data will be stored in the row or outside the row depends on how you specify it using the system stored procedure sp_tableoption ....

And what Johan meant was that the original error you got was nothing to do with the database being corrupt,...

The *only* way to fix this in the current database is to go in and hack the system tables using the procedure I've documented.

You could migrate to a new database...

First off, please post in complete words rather than text-message jargon - it makes posts much easier to read.

Your I/O subsystem has issues - plain and simple. The first error...

A PHYSICAL_ONLY check will check the integrity of the allocation bitmaps and then read every allocated page in the database and do a page audit. It skips all inter-page checks....

If you run a full DBCC CHECKDB you'll see a *lot* more corruption errors as a result of the errors you've already posted.

You've got some interesting corruption in one of...

Not off the top of my head - Google 'sql kb index rebuild corruption' and you'll get some links.