troubleshooting Question

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

Avatar of hyemar
hyemar asked on
Storage SoftwareVMwareDisaster RecoveryDell
7 Comments4 Solutions1500 ViewsLast Modified:
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!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 4 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros