A db_owner can do anything to the database, including drop it.

The mdf is corrupt, no matter what the tool tells you. You've got damage at least to the metadata, that's preventing the DB from going into emergency mode. There could...

Sleeping actually. I'm in one of the european time zones, so...

Sunil Padarath (5/13/2010)

---

Thanks Gail

I get this error when i run set to emergency

Msg 602, Level 21, State 33, Line 1

Could not find an entry for table or index with partition...

And you're certain there were no other backups made?

What's the restore script that you used?

Toast. As in 'your database is ...'

Little expensive though, and flights around the time of the WC are more expensive than...

CirquedeSQLeil (5/13/2010)

---

GilaMonster (5/13/2010)

---

BrainDonor (5/13/2010)

---

Normally when driving along, if there's been a nasty accident I just drive past (as long as I can't do anything to help) - I don't 'rubberneck'...

That I could understand, different SET options so different plans and one entry per plan. However ...

rdouglas66 (5/13/2010)

---

The statistics are completely different as are the cache times but yet have...

Yup, because now the index is seekable...

I'm considering finding a hole and pulling it in...

No idea, I don't understand what you're trying to do here. Maybe a bit more of an explanation of...

No.

Live being server A or B?

If B, then yes, you can restore a diff providing the full backup was restored WITH NORECOVERY, leaving the DB offline and allowing for...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/