SQL Server 2005 failover cluster vs. log shipping
Posted on 2008-11-06
I have 2 new identical servers. One will be a production server, the other a hot spare.
I cannot do mirroring because the db's have to be in bulk-logged recovery mode which mirroring does not support.
Can someone explain failover clustering and log shipping and does anyone have experience that would lead them to a recommendation?
Do I need anything more than 2 identical servers for clustering? The 2 machines are in different buidings and are connected by Fibre.