if your database recovery mode is set to "simple", then from BOL 'You get an error if you try to back up the log while in SIMPLE recovery mode'

try http://www.storagereview.com/guide2000/ref/hdd/perf/raid/index.html

HT is actually not two processor cores on one silicon die (like the processors we'll see in year or two). It's about maximizing usage of existing execution units (ALU, FPU,...

hi,

are you sure you need SQL 2000 Enterprise edition for partitioned views?

I'm running it on single server just fine.

ps