Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Course Of The Month
6 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Equallogic replication of entire virtual SQL-server and its data in vSphere
Posted on 2012-12-30
Hi.
We've recently installed a SQL server 2008R2 in our VMware vSphere 5.1 environment.
Some facts
Based on the facts above, I was wondering if anyone has any experience/knowledge with Equallogic volume replication and/or the Smart Copy functionality in VSM.
Feel free to ask for more information if you need.
Thanks, in advance!
We've recently installed a SQL server 2008R2 in our VMware vSphere 5.1 environment.
Some facts
All the data is stored in an Equallogic PS4100XV SAN array
The Windows 2008R2 OS is stored on a separate VMDK HD
The SQL data is stored on another VMDK HD
The SQL-server and its VMDKs is stored on a separate SAN volume
We've installed DELL Equallogic Virtual Storage Manager (VSM) into our vSphere environment
The SQL server contains approximently 450 databases, with relatively low-transcation rate
We have a secondary Equallogic PS4100E SAN array at a secondary site that we want to replicate the SQL-volume to for disaster recovery. We do not have any physical or virtual servers at the recovery site at the moment
Based on the facts above, I was wondering if anyone has any experience/knowledge with Equallogic volume replication and/or the Smart Copy functionality in VSM.
1. Question 1
Will it be possible to restore the entire Windows Server with its installed SQL-server and its data at the recovery site by only replicating the Equallogic volume? The virtual SQL-server will be powered ON when the replication is being done.2. Question 2
Is it best to use the VSM and its Smart Copy functionality combined with replication to preserve the state of the VM or isn't it nessecary?3. Question 3
Any other thoughts/suggestions?Feel free to ask for more information if you need.
Thanks, in advance!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
7 Comments
Active today
Q1. Yes it is possible, however, you are replicating the LUN which includes the Virtual Machines.
Q2. Yes, it is best to use Equallogic tools to perform the replication.
Q3. Once you have the LUN replicated to the other Equallogic SAN, you will need to present this LUN to the ESXi servers, just like you have done at Site A.
When you have presented the LUN, (re-scan storage), you will be able to Add the VM to your Hosts Inventory and Power On.
If you want a more automated system, you will need to look at VMware Site Recovery Manager.
Q2. Yes, it is best to use Equallogic tools to perform the replication.
Q3. Once you have the LUN replicated to the other Equallogic SAN, you will need to present this LUN to the ESXi servers, just like you have done at Site A.
When you have presented the LUN, (re-scan storage), you will be able to Add the VM to your Hosts Inventory and Power On.
If you want a more automated system, you will need to look at VMware Site Recovery Manager.
Active today
Yes, no problems fire away.
We generally use it with VMware Site Recovery Manager, because clients prefer an automated solution!
We generally use it with VMware Site Recovery Manager, because clients prefer an automated solution!
Active 1 day ago
I see.
Im reading about "Storage Recovery Replica" and "Smart Copy Replication" now.
Because we only have the secondary SAN group and no physical/virtual servers at the recovery site at the moment, I see that the "Storage Recovery Replica model" is the only option for us in VSM for now. Do you agree?
I'm also reading that "Storage Recovery Replica model" is saving the state of the virtual machine, thats sounds like good news. The doc says:
Thank you so much for good help so far.
Im reading about "Storage Recovery Replica" and "Smart Copy Replication" now.
Because we only have the secondary SAN group and no physical/virtual servers at the recovery site at the moment, I see that the "Storage Recovery Replica model" is the only option for us in VSM for now. Do you agree?
I'm also reading that "Storage Recovery Replica model" is saving the state of the virtual machine, thats sounds like good news. The doc says:
Performs restore operations (selective restore and rollback)
1. Q1
Do you understand what they mean by that phrase?2. Q2
Do you think "Storage Recovery Replica model" is the model to use for now in our situation?Thank you so much for good help so far.
Active today
Yes, if you have NO Host Servers at the Secondary Site, you just want to use the Storage Recovery Replica model, to allow you to "rollback a LUN" from the DR site in case of VM failure.
Active 1 day ago
I see. In case of disaster, will it also be possible to attach the volume to a (future) ESXi host at the secondary site with this model?
Featured Post
June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB.
Just connect to vCenter DB(default DB should be VCDB and using…
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database.
Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space.
Verify that the path to the shared storage is valid and that data can be written to that location:…
Suggested Courses
Course of the Month6 days, 9 hours left to enroll
724 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.