Windows Sharepoint 2010 high availability solution

We have a one server sharepoint 2010 solution running on windows 2008 R2 64 bit. We need to add high availability to the enviroment, so we got an extra server. Our client has a Document website on the Sharepoint 2010 server. What are the recommended solutions to set up replication?

Thanks for the help

LVL 1
scubablueAsked:
Who is Participating?
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.

zephyr_hex (Megan)DeveloperCommented:
i don't think your question is specific enough.  there are various ways to provide "high availability".  which approach are you taking?

this article describes the options, and has links to resources for each method:
http://technet.microsoft.com/en-us/library/cc748824.aspx
0
scubablueAuthor Commented:
We are going to have a Sharepoint 2010 server. We would like to have a spare server in a different datacenter connected thru a VPN. We are going to need to copy all the live changes from the lice SQL2008 Sharepoint database to the spare server DB. What is the best way to accomplish that. Will SQL Replication copy the live database? Will it work with Sharepoint 2010?

Thanks
0
Ted BouskillSenior Software DeveloperCommented:
That method won't work.  SharePoint binds server configuration into the registries and the database that includes the server names.  SQL replication is unsupported for that usage and would kill performance.

SharePoint 2010 does support mirroring to two SQL database servers but performance of the SQL mirroring over VPN could be slow.  To use Mirroring you cannot use the embedded SQL and need to use two licensed copies of it, plus you need a 3rd SQL server as a witness server for the SQL mirrors.

Do you want failover for the front end servers?  Then you need to setup a hardware load balancing device to redirect DNS names for the web applications because two servers in different data centers can't use Microsoft's free network load balancing.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

scubablueAuthor Commented:
Hello,

Thanks for the response.

Just to make sure I am understanding the process to set up 1 sharepoint 2010 live environment and a Backup sharepoint 2010 environment (we would like to replicate all the latest change in the DB)

I will need 2 sharepoint 2010 standard server licenses with sql 2008. 1 extra sql 2008 db server to run as a watchdog for the SQL 2008 Mirror.
I do not want fail-over in the front end servers. We want to set up a Active/Standby environment to and extra DNS entry.

In case of an emergency we will fail to the backup environment and then schedule a transfer back period. Let me know if you have any suggestions

Thanks

0
Ted BouskillSenior Software DeveloperCommented:
Sorry, but you misunderstood.  It's not a replicate or hot standby.  It's a configuration of one SharePoint farm spread to two geographic locations that I am recommending.  You can use a DNS entry to flip between front end servers to present the web pages, however, both web front ends are active participants in the same SharePoint farm so you do not need to SharePoint 2010 standard licenses.
0
scubablueAuthor Commented:
The problem we are having is that at times the main headquarters( for being in a new building ) need to be power down 3 time a year for 3 days. So with this method we will have a replicated DB but no we application to log into. Is that correct? What will be the recommendable solution in this scenario

Thanks
0
Ted BouskillSenior Software DeveloperCommented:
My recommendation will work perfectly in that scenario because of the SQL mirroring which is fully supported by SharePoint 2010.
0

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
scubablueAuthor Commented:
So I will create a farm or 2 application (one local-one datacenter) pointing to a DB(local) and the failover DB will be in the datacenter. also set up a watchdog DB server to monitor SQL monitoring.
Thanks
0
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 SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.