Solved

Equallogic replication of entire virtual SQL-server and its data in vSphere

Posted on 2012-12-30
7
1,411 Views
Last Modified: 2016-11-23
Hi.

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!
0
Comment
Question by:hyemar
  • 4
  • 3
7 Comments
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 38730718
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.
0
 

Author Comment

by:hyemar
ID: 38730772
Thanks for the reply!

Is it OK if I ask you about your experience with this?
0
 
LVL 118

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 38730964
Yes, no problems fire away.

We generally use it with VMware Site Recovery Manager, because clients prefer an automated solution!
0
Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

 

Author Comment

by:hyemar
ID: 38731005
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:

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.
0
 
LVL 118

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 38731063
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.
0
 

Author Comment

by:hyemar
ID: 38731187
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?
0
 
LVL 118

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 38731195
Yes. It's just a LUN.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now