• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

SQL Server 2005 failover cluster vs. log shipping


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.

  • 2
1 Solution
If the machines are geographically apart, it could be a problem for clustering.  For your case, you'd only need the 2 servers though.

I am not 100% sure is a good idea to do log shipping using bulk logged, but you can probably do it.
Bonnie_KAuthor Commented:
I read that replication is not a good form of high availability either.  

Why would the geographical status of the servers matter for clustering?  I don't understand clustering as I have always seen it as something over my head and over budget, but am wondering with our hardware if it is possibility.

I will look more into log shipping and bulk logged databases.

What do you think about replication?
>>I read that replication is not a good form of high availability either.  
that is correct

It matters because I think ** you have to buy some specialized hardware if you're going to use them over a WAN.

Replication is a no-go for HA.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now