help with setting up DR SQL Server 2012 at datacenter

king daddy
king daddy used Ask the Experts™
on
Greetings,

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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jose TorresCertified Database Administrator

Commented:
rpliner,

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.

Author

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 Administrator
Commented:
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
IT Engineer
Distinguished Expert 2017
Commented:
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.

Author

Commented:
sticking with Veeam for now but I appreciate the guys input.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial