king daddy
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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sticking with Veeam for now but I appreciate the guys input.
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.