Page 1 of 2

HP 3PAR VSS Provider

Posted: Mon Aug 25, 2014 11:50 am
by nsnidanko
Hi All,

I am looking at taking application consistent snapshots (MsSQL for example) with 3par hardware provider. Has anyone had any success doing it (such as via vssadmin command?)

Thanks

Re: HP 3PAR VSS Provider

Posted: Mon Aug 25, 2014 1:44 pm
by hdtvguy
Physical servers or virtual?

Re: HP 3PAR VSS Provider

Posted: Mon Aug 25, 2014 2:02 pm
by nsnidanko
Physical. So I am trying to achieve DR solution: create VSS consistent snapshot on primary 3par and replicate it to the 3par in DR. These changes have to be incremental.

So far I've achieved first part: creating application consistent 3par snapshot via VSS. You need to install 3par VSS provider.
Here's the script for diskshadow:

Code: Select all

#Diskshadow script file
SET CONTEXT PERSISTENT NOWRITERS
BEGIN BACKUP
ADD VOLUME E: ALIAS 3par_test
CREATE
END BACKUP
#End of script


Now I have 3par vss consistent snapshot on the primary; how do I replicate it and inject into the VV on DR side? Any ideas much appreciated.

Re: HP 3PAR VSS Provider

Posted: Tue Aug 26, 2014 5:08 am
by Cleanur
Only way I can think is that you'd want these volumes to be in a RC group already with a full sync completed. Assuming it's periodic async and you're controlling the sync interval (see next step), then you could use syncrcopy to get the changes to the remote site. HDTVGuy has done something similar at scale but VSS adds some complexity, this functionality is already built into Recovery Manager for SQL but it does have some limitations around use cases.

Re: HP 3PAR VSS Provider

Posted: Tue Aug 26, 2014 5:46 am
by hdtvguy
I am not a fan of 3par's Recovery Manager products, but they make a RM-SQL that may help you out with this.

Re: HP 3PAR VSS Provider

Posted: Tue Aug 26, 2014 7:57 am
by nsnidanko
Recovery Manager for SQL was the first product we tried to use for SQL DR purposes but it not designed for this. There is luck of understanding within HP organization on what this product is designed for. Naming of the software is deceiving too. We spent weeks with many levels of support and professional services trying to get it working until HP finally admitted that RM-SQL is not the answer and they were wrong.

RM-SQL requires source SQL server to be on-line at all times. You would use RM-SQL when you have two 3pars connected to the same SQL server. Let's say you need to run huge report or do some testing on the production database - you would use RM-SQL to load this data on to secondary 3par, thus you're not affecting your production.

Re: HP 3PAR VSS Provider

Posted: Tue Aug 26, 2014 2:49 pm
by RitonLaBevue
I deployed RM SQL with some customers and two arrays in synced replication with no troubles.
In the same time you make snapshots of primary and secondary volumes.
You can schedule them... So, what else ?

Re: HP 3PAR VSS Provider

Posted: Tue Aug 26, 2014 3:56 pm
by nsnidanko
Here's what I am referring to with RM-SQL:

Image

When you have disaster (i.e SQL Server in site A becomes unavailable) you're unable to mount volume, restore data, etc via Recovery Manager Backup Server 2.

Re: HP 3PAR VSS Provider

Posted: Wed Aug 27, 2014 6:01 am
by hdtvguy
nsnidanko wrote:Recovery Manager for SQL was the first product we tried to use for SQL DR purposes but it not designed for this. There is luck of understanding within HP organization on what this product is designed for. Naming of the software is deceiving too. We spent weeks with many levels of support and professional services trying to get it working until HP finally admitted that RM-SQL is not the answer and they were wrong.

RM-SQL requires source SQL server to be on-line at all times. You would use RM-SQL when you have two 3pars connected to the same SQL server. Let's say you need to run huge report or do some testing on the production database - you would use RM-SQL to load this data on to secondary 3par, thus you're not affecting your production.


The fact that you want to take VSS snaps would also indicate the source SQL server is online as well.

Re: HP 3PAR VSS Provider

Posted: Wed Aug 27, 2014 8:21 am
by nsnidanko
hdtvguy wrote:
The fact that you want to take VSS snaps would also indicate the source SQL server is online as well.


Yes, correct that part is working fine. Taking VSS consistent snapshots and getting them over onto DR 3par works well. We hit a wall with RM-SQL software for the "disaster recovery" part. It's the "recovery" piece that's not working for us. When we try restoring data via RM-SQL software in DR site with primary side down (thus source SQL server not available), RM-SQL software says it needs to have source SQL on-line. Of course it's not possible in case of site disaster :)

So we are looking at having it scripted to execute via VMware SRM as part of recovery plan.

P.S.
I found it and will post solution as soon as I develop script.

Thanks everyone.