Thanks to insights gained from http://www.pluralsight.com/training/Courses/TableOfContents/sqlserver-database-corruption and http://www.pluralsight.com/training/Courses/TableOfContents/sqlserver-advanced-corruption-recovery-techniques I was able to deal with the corruption. Although at first it díd apperar te be a unrepairable error the corruption turned...

double 🙂

jharting (8/27/2014)

---

Command(s) completed successfully.

Now I''ll put the Db back...

Command(s) completed successfully.

Now I''ll put the Db back in...

The SAN guy's already reported some connectivity issues on the fiberchannels around that time 🙂

CheckDB with tablock resulted in:

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281964609732608 (type Unknown), page (40306:-923434249)....

Thanks,

Since daily full backups are made, a page restore from about a week ago would prove difficult; We'll discuss this with the business 🙂

Thanks again 🙂

GilaMonster (8/26/2014)

---

Restore from backup. That's not repairable.

I would hope, that for the heart of your accounting, you have log backups. Assuming that you do, restore the clean full backup WITH...