From: "Geo." 

"Frank Haber"  wrote in message
news:40dd74cf{at}w3.nls.net...

> Very valuable, thanks, and not something I would have thought of.  So a
> lightly-loaded vertical business app (customer database) would be fine on
> mirrored IDE, except for reindexing day, I guess.

I have run sql server on a mirror setup, but the log file was on an
non-mirrored partition.

Writing is slower, because it has to write to both drives, reading is
faster because it can read from either drive (whichever is less busy). On
average it balances out but an app that does a lot of writing or long
writes it might be noticably slower. That's with IDE mirrors anyway, with
scsi you might not notice so much.

Geo.

--- BBBS/NT v4.01 Flag-5