Windows – How to setup IIS7 and SQL Server failover on a Windows Server 2008 R2

failoveriissql serverwindows

We would like to ensure minimal down time for our hosted software, which is .NET and SQL Server based. We would like to setup a multi-site cluster so we would have two servers at geographically dispersed locations. We don't need the whole server to be mirrored, just the IIS settings and directories and the SQL Server database. I have read up on Server 2008 R2 multi-site clustering but the Windows Solution relies on finding some third party tools to replicate the data across the server. I was hoping that someone could shed some light on an easy way to set this up.

Best Answer

IIS cannot be clusted. But you can use the Network Load Balancing feature to build a web farm of IIS for failover. For replicating data, you can use robocopy if you don't like some third party tools.

Related Topic