SQL 2008 High Avaliability

Hi All, need some advice really.

I am migrating a companies SQL databases onto new virtual servers, they currently have two machines and a witness in a HA mirrored enviroment.

Moving forward the "Primary" SQL server will be offsite in a datacentre, with a backup or secondary server in the local office (this is the way they want it as 65% of the workforce are field based) these will be connected via an MPSL network on the same subnet.

What is the best option for this, are there any enhancements in SQL 2008 R2 that I can use to my advantage or shall I keep them mirrored (if I do I'm not going to use a witness as all the applications that rely on them need manual intervention anyway).

Thanks

K
techmissAsked:
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.

techmissAuthor Commented:
Oh one other thing, if I do use mirroring and the primary is off-site, all users the are in the local office will be writing to the remote server, this, in-turn, will then commit these changes to the local office - a possible source of congestion?

0
ChrisCommented:
do you have any resilience built into your virtual environment i.e. storage replication
0
techmissAuthor Commented:
Not yet, but I have this option...

0
Identify and Prevent Potential Cyber-threats

Become the white hat who helps safeguard our interconnected world. Transform your career future by earning your MS in Cybersecurity. WGU’s MSCSIA degree program was designed in collaboration with national intelligence organizations and IT industry leaders.

ChrisCommented:
What size links do you have between your sites? Mirroring or tlog shipping would be the best way to get disaster recovery but with out storage replication you won't achieve business continuity with good performance
0
techmissAuthor Commented:
Thanks for your reply,

We have a 15Mbps fibre connection between sites, I was thinking mirroring so I'm glad you suggested it...

0
ChrisCommented:
do a quick check on the size of your DB's and the amount of transactions or size it gorws everyday as this will give you an idea on how much traffic would go over the link

If its a lot you might stress the fibre link and tlog shipping might be a better choice
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
techmissAuthor Commented:
Thanks, I will investigate and make a decision.
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 SQL Server 2008

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.