Hi there Jeff.

Very interesting story you have there. It wasn't that long, or my levels of interest went sky high when i started to read it.

The need to buy new...

Hi there Glenn.

I really enjoyed your post. Very concise and straighforward. Neverthless i think 64GB of RAM is bit overkill to a database that's only 16GB althgouh, like i said...

Hi.

Thanks for posting. 🙂

I'm thinking something along these lines:

- AD+DC = 4GB

- SQL Server + simple messaging services= 10GB

- Retail (20 CAL) = 8GB

- RDS (5 CAL)= 4GB

- Production (1...

whale

Hi

I've never done it through Attach/Dettach, but by restoring from a fresh, perfectly good backup it went like a breeze.

But like the previous poster said, test it. Although dettaching...

Solved.

RAID array had one black sheep.

Too bad that the card is so cheap it doesn't give any warning...

Not really, no.

Thanks for bringing that up, i'll now check if the write-caching gets enabled after each boot.

Just finished going through the procedure of running CHECKDB on another spin.

The first run required REPAIR_REBUILD. After that i ran CHECKDB 3 times in a row, and the results were...

GilaMonster (11/29/2012)

Ow, that's a waste of time. Ditch that plan entirely, go grab Ola's index maintenance script. Use that. Put checkDB (and your backups) in a separate plan

At this point...

These results were obtained running the command right from a query window.

I do have a scheduled maintenance plan (runs everyday...

Hi Gail, thanks for the quick reply.

On this run of CHECKDB WITH ALL_ERRORMSGS i got...