SQL Server 2005 failover cluster vs. log shipping

Posted on 2008-11-06
Last Modified: 2011-09-20

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.

Question by:Bonnie_K
    LVL 60

    Expert Comment

    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.

    Author Comment

    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?
    LVL 60

    Accepted Solution

    >>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

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now