I currently have a single SQL2008R2 that I need to add redundancy too..
The failover server will be located at a different physical site, but the network segment,( 100Mb between sites) will still be within my Windows network security domain.(single domain for all sites)
I need it to be a passive failover.. Can anyone direct me to a good site that explains how to go from a single SQL Server to a failover cluster..
This is our payroll system and I need to have a backup site in case of a power outage or hardware failure..