Yup - if CHECKDB can't get the memory it needs, it will fail. It processes tables in batches, with at least one table plus indexes per batch. I'm surprised it's...

Another question with an arbitrary, not-well explained answer. The actual index structures are exactly the same for all index types except full-text indexes. So how is 4 the correct answer?...

WTF? A question where you're supposed to spot a syntax error and figure out the correct answer, rather then working through the logic that seems right? This question sucks.

Wrt the one line sales pitch at the end of my last two QOTDs, this is deal I worked out with Steve Jones. I provide a couple of really good...

@Festeron: Nope - the log backup containing the minimally-logged operation cannot be used for a STOPAT restore to any point in time covered by the entire log backup. For this...

lbowman (6/8/2010)

---

Based on the explanation, the use of the term "a lot smaller" must be the reasoning for excluding answer "D". Even though http://msdn.microsoft.com/en-us/library/aa173529(SQL.80).aspx states.

The Bulk-Logged Recovery model provides protection...

Hugo Kornelis (6/8/2010)

---

Good question, Paul!

In your explanation, you write that log backups are about the same size as when full recovery had been uses. This matches my expectation, but in...

Interesting - as those aren't the errors in the DemoRestoreOrRepair database I provide.

Anyway, I don't understand the point of your post. CHECKDB is clearly telling you that you need to...

My guess would be http://support.microsoft.com/kb/978430. Fixed in SP3 CU9.

@Gail No

@alex Yes, which is why I said it would depend on database size and network bandwidth. My point was that the potential risks need to be understood before doing...

Hmm - there are some nasty potential problems with doing what you describe and I would not recommend it in production:

1) what if the clustered index being rebuilt is very...

It's a bug still - unlikely to be fixed. Call in to Product Support so they know you hit it - call will be free as it's a bug.

That's the file header page for the mdf - the first page that SQL Server looks at and one of two pages that corruption cannot be tolerated on nor repaired...

alen teplitsky (4/23/2010)

---

good article

in my experience the biggest impediment to running checkDB on a regular basis is management. i've seen it run without the repair or the all info messages...

Indeed -...