topic Re: Snapshotting SQL LUN? in StoreVirtual Storage

Snapshotting SQL LUN?

Paul Hutchings — Tue, 27 Oct 2009 17:00:28 GMT

Considering a VSA to hold a few TB of SQL data (low transactions just large).

I don't know if the LUN would be presented to the SQL box via MS iSCSI initiator, or as a VMDK, but I'm a bit unclear on:

a) Lefthand "Software agents" for SQL to ensure a "clean" snapshot?

b) Licensing - AIUI these are NOT included in the VSA license? Any part codes or ballpark costs?

Thanks,
Paul

Re: Snapshotting SQL LUN?

René Loser — Wed, 28 Oct 2009 13:27:37 GMT

Hi Paul,

With the new release of VSS-Provider and CMC-GUI from November you can do "Application Managed Snapshots" direct from the LeftHand GUI.
This works for non-virtualized Windows Servers incl. 2008R2.
As far as i know it works with with RAW-Devices for VMware.

The provider- and GUI-Update is for free.

You can download it directly from the ftp site:
ftp://saniq8_1:SANIQ8_1@hprc.external.hp.com/
ftp://saniq8_1:SANIQ8_1@15.192.32.69/

Mothership1 directory!

regards,
reNe

Re: Snapshotting SQL LUN?

teledata — Wed, 28 Oct 2009 14:18:49 GMT

Another note is that the raw devices in VMware CAN make use of MPIO if you implement iSCSI binding with vSphere 4.

Re: Snapshotting SQL LUN?

Bryan McMullan — Mon, 02 Nov 2009 15:48:45 GMT

We snapshot a few high performing SQL databases. We present the volume to SQL through iSCSI. We've tried presenting it as a VMDK as well, but it seemed to perform worse.

We've restored many DB's without issue using just the standard LHN snapshot (no application managed version). I believe that is the same thing as what you would get with the VSA software.

If you were nervous, you could also just do a SQL Backup (.bak file) to another connected volume as well. There's quite a few options when it comes to SQL backups.