I don't understand your question - rollbacks only occur when something goes wrong or you explicitly rollback a transaction - how could you calibrate them?

Not necessarily - if something goes wrong the transaction will rollback automatically

Here's the list off the top of my head of what will cause log reads:

1) transaction rollback (whether you explicitly start a transaction or do single-statement implicit transactions)

2) crash recovery

3)...

On 2000 it will actually fix up incorrect PFS page free space bits silently, even if you don't say to do repairs. There was a bug in the algorithm that...

No problem - always enjoy this stuff.

@jack-2 - Yup, although it's very dangerous to do so, in terms of availability, not corruption. I suspect they're on an earlier version though.

@kwoznica - No, no possibility of corruption...

This is 2000 or earlier, right?

Looks like you're using a backup tool that is freezing I/O on the server to do its backups and hasn't thawed the I/O properly. This...

The backup wouldn't change anything (it never does) but the shrink might have in such a way that the repair would work. 2000 is a bit dodgy as I said.

You...

No, that's not possible either. The upgrade changes the database so 2000 can't understand it and bumps the version number from 539 to 610 or 611. Compat mode has nothing...

How did the restore of the 2005 database to the 2000 server work? That's not possible at all. From the sequence of errors, it looks like the restore didn't actually...

No problem Mindy - you could have just sent me email - I would have answered you 🙂

This is output from a 2000 server, right? FYI this is the 2005+ specific corruption forum. But I'll answer the question anway.

My guess is you have multiple CPUs and Enterprise...

Gail - these are SQL 2000 corruptions (from the CHECKDB error messages). The rules for when a system table can be repaired are a little different between 2000 and 2005,...

Hear, hear. As is, this article is terrible. You don't explain any of the reasons for doing this (or more importantly, not doing it).

You also say you must take a...

And this isn't a data corruption topic - please post in the appropriate forum. Thanks.