help with setting up DR SQL Server 2012 at datacenter


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
king daddyAsked:
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.

Jose TorresCertified Database AdministratorCommented:

Do you still need assistance.  One note DR and High Availability are not always the same.
Could you please be more concise on what you are trying to achieve.
king daddyAuthor Commented:
Hi Jose,

I think I have DR covered through Veeam so I guess I am looking more at HA. I am trying to get my RTO down as much as possible using Veeam and Microsoft options. I have a SQL 2012 server in the office and want to have a stand-by ready in the datacenter, preferably as up to date as possible. I have been using Veeam for replication throughout the day but was looking for something that integrated SQL technologies. Seems like Veeam may be the way to go from what I have been reading.

thanks for following up
Jose TorresCertified Database AdministratorCommented:
Unfortunately I am not familiar with Veaam.
SQL Server AlwaysOn feature may be something you want to look at.

But you may want to look at this article it may give you some insights.

VMware HA is Not Database Server High Availability
Vitor MontalvãoMSSQL Senior EngineerCommented:
rpliner, for all above solutions you mentioned, only AlwaysOn needs Enterprise Edition (EE). So, if you can't upgrade to EE then you still have Log Shipping and Mirror.
You can also use only SQL Server Clustered Instance as High Availability solution but there's a single point of failure (storage).

Let us know which solution you prefer so we can direct you better.

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
king daddyAuthor Commented:
sticking with Veeam for now but I appreciate the guys input.
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

From novice to tech pro — start learning today.