?
Solved

SQL 2008 High Avaliability

Posted on 2011-10-21
9
Medium Priority
?
225 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:techmiss
  • 4
  • 3
7 Comments
 

Author Comment

by:techmiss
ID: 37005355
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
 
LVL 18

Expert Comment

by:Chris
ID: 37005516
do you have any resilience built into your virtual environment i.e. storage replication
0
 

Author Comment

by:techmiss
ID: 37005625
Not yet, but I have this option...

0
Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

 
LVL 18

Expert Comment

by:Chris
ID: 37022857
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
 

Author Comment

by:techmiss
ID: 37030099
Thanks for your reply,

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

0
 
LVL 18

Accepted Solution

by:
Chris earned 2000 total points
ID: 37030211
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
 

Author Closing Comment

by:techmiss
ID: 37030429
Thanks, I will investigate and make a decision.
0

Featured Post

Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to fix “Unable to mount database. (hr=0x80004005, ec=1108)”.
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

621 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