What, specifically do you want to know, beyond what is documented in Books Online for that DMV.

Which one of the commands I gave you returned that? Is that the entire output?

Does your database have read_committed_snapshot enabled?

You can't rebuild indexes on system tables.

Take the DB into single user mode and run:

DBCC CheckDB ('RXL084BAY',Repair_Rebuild) with no_infomsgs

Post any output please. Once complete, run this:

DBCC CheckDB ('RXL084BAY') with no_infomsgs,...

Not estimated. Actual plans. Save as .sqlplan files and attach them

It's the same index, but different rows of that index (see the different values for ID in the keylock). It's not the same resource

Key lock is a lock on...

Um, why?

It will hold...

Bear in mind that it could be something as simple as an open transaction. That could require reading through multiple log backups.

How many days do you have spare to do...

While it's possible to query a log backup, the results are not easy to interpret. There are no queries listed in the log, just the records of what objects were...

Because you can run a drop database within a transaction, the...

In what context and where?

So what happens if there's a drive failure? Do you tell the customer 'Tough luck, you've lost everything'?

Ed Wagner (6/9/2014)

---

Backing it up will also mark the pages in the transaction log as backed up, so they'll be available for reuse. That means it won't have to...

Not possible, because DDL triggers are AFTER triggers. They fire after the action has completed. Any trigger which fired after a restore database had run would not be able to...