Just wanted to give a big THANK YOU to Michael for assembling the non-domain member setup script - worked great!

Re: the clustering/DM debate

Depends on what you're doing - for me, DM was a better solution than clustering.

Production site is 2 web, 2 db (+ witness)

IT Team is 1 person (me)

Application is brand new, so ADO/Connection strings are not a problem

Low database count (< 5)

Small database size (< 1 GB)

All Servers are on VMWare - SQL cluster was more headache not to mention the licensing + hardware burden

- Virtual Network removes many failure/redundancy issues

- Hardware Failures handled by VMotion to an alternate ESX Server

Greater peace of mind has been achieved! Windows OS failures are easily covered by this process, except a bad windows update of course

The only thing missing is accessing the mirrored data for reporting - but that can be bypassed by replicating the mirrored database, which is next on my list.

Mike