How do I get failover functionality on Server 2008 R2 Standard and SQL 2008 Standard
Posted on 2011-10-27
I am trying to set my client up with failover for file services and SQL. They've purchased two identical servers with Windows Server 2008 Standard equipped with RAID-1 storage. While attempting to install SQL2008 Standard in a two-node configuration, it complained Windows Server was not configured for clustering. I am trying to make the servers failover for file, print, and SQL services; Active Directory is easily covered ;-)
Can I set up active/passive failover of Windows Server 2008 Standard or do I need Enterprise/Datacenter edition and a SAN? If Windows Standard cannot natively do the failover, what can I do to make this happen? SQL subscriptions? Robocopy? vCenter? The servers are already onsite, so changing out the operating system is not an option.
Any recommendations on configuration and relevant reading materials would be greatly appreciated.