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
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
sticking with Veeam for now but I appreciate the guys input.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.