Link to home
Start Free TrialLog in
Avatar of king daddy
king daddyFlag for United States of America

asked on

help with setting up DR SQL Server 2012 at datacenter

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
Avatar of Jose Torres
Jose Torres
Flag of United States of America image

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.
Avatar of king daddy

ASKER

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
SOLUTION
Avatar of Jose Torres
Jose Torres
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
sticking with Veeam for now but I appreciate the guys input.