We help IT Professionals succeed at work.
Get Started

help with setting up DR SQL Server 2012 at datacenter

Last Modified: 2016-04-22

I need some ideas regarding a SQL server set up where I have my production SQL server in the office and another in the datacenter. I have SQL 2012 standard. It is running on server 2012 R2. It is a VMware VM running on a 5.1 ESXi host. I use Veeam for backup in the office then a copy goes to the datacenter. I also use Veeam to replicate the office SQL server to the datacenter (also running ESXi 5.1). I don't have SRM.

I have read articles on log shipping, mirroring (apparently being deprecated), always on availability groups (I have standard though, not enterprise), and always on failover clustering. I also saw live migration but I think that is for Hyper-V not VMware.

If I can set up failover clustering across the WAN (dedicated point-to-point between office and datacenter) I think I would do that. I may also just keep using Veeam replication but not really sure how well it works for automatic failover (or manual for that matter) and I only run the replication every few hours right now.

Thanks a lot
Watch Question
IT Engineer
Distinguished Expert 2017
This problem has been solved!
Unlock 2 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE