Building fault tolerant IIS/MSSQL stacks (Sql Clustering?)

view full story

http://serverfault.com – We had a raid failure yesterday on a server that was hosting databases and IIS. We're trying to determine the best way forward in terms of our IIS and MSSQL hosting environment. We'd like redundancy on the IIS side and the SQL side. For some of our applications we're using pfSense to load balance two web servers (sticky sessions don't work well so we've gone to session state in the database). These two web servers hit a single MSSQL instance running SQL Express (free, our databases are very small, the largest is 1GB). I feel reasonably confident in our IIS load balancing as when we run pa (HowTos)