I have a SQL Server 2005 database on one server which on some days can get up to a million new records. I would like to create a working backup of the database on a secondary server so that if the first fails the second can be used.
I originally thought a failover cluster would be the best approach, but when I installed my second copy of SQL Server the option was grayed out. I don't need the second server to be a hot backup...it only needs to be ready if the first fails and no records should be lost between the down time. Can someone please guide me in the right direction? Would replication do the same thing as a failover cluster? Why was the failover option grayed out?