Our old 2000 server was clustered and was problematic at best due especially due to the shared drive requirement. Drive hiccups on the RAID box were our most common problem.

For 2005 we implemented mirroring which so far has been satisfactory. Since the drives are on two physically separate systems, we can even bring down the drives for maintenance (firmware etc) while keeping the database up.