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.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.