No worries 🙂

Yes, that's what I said two replies further up in the thread...

They had to have something else going on, or they're confused by nomenclature - snapshot just can't get bigger than the database - once all pages from the database are...

It's not - it can't get any bigger than the size of the database at the time the snapshot was created. The only time the snapshot can be bigger than...

I guess you could interpret the semantics of the article prose either way - at best it's ambiguous.

Snapshots are one of the features I liked the most when I helped...

Here's my blog post which explains how this works and how transaction rollbacks do NOT cause pages to be copied into the database snapshot.

http://www.sqlskills.com/BLOGS/PAUL/post/Misconception-around-database-snapshots-and-transaction-rollbacks.aspx

Thanks

This is kind of obvious. A rollback of a transaction is a logical operation which generates more changes to the database - there's no concept of simply undoing a transaction's...

CHECKDB's not going to fix this. What's weird is that it looks like the text blobs for all sysindexes rows have been lost - did something nasty happen to this...

Well, you've hit a bug somewhere in the server - very hard to tell where though without having a debugger attached to it.

A 'kept' page is one that has a...

Which build of 2005 are you on?

Have you used any of the following recently in the database: online index operations, MARS, DML triggers? These all use versioning under the covers...

See CHECKDB From Every Angle: How long will CHECKDB take to run? and CHECKDB From Every Angle: Consistency Checking Options for a VLDB.

Seems like you're missing an 'h' from Thanx...

You don't want to turn it on unless you're *not* covered by page checksums already. It's going to vastly slow down reads while it does the extra auditing.

No problem if...

Thought this would make a good blog post: see What can cause log reads and other transaction log questions

Yes - it's entirely feasible. How much transaction log do you generate in a day? How big is each log backup? The total log backups for a day should roughly...

Not sure of Trace will trace system-issued rollbacks or not. Engineer a full transaction log with a long running transaction and you can check it out.

You can look for rollbacks...