Here's what I am referring to with RM-SQL:
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.
| HPE Storage Users Group https://3parug.net/ |
|
| HP 3PAR VSS Provider https://3parug.net/viewtopic.php?f=18&t=877 |
Page 1 of 2 |
| Author: | nsnidanko [ Mon Aug 25, 2014 11:50 am ] |
| Post subject: | HP 3PAR VSS Provider |
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 |
|
| Author: | hdtvguy [ Mon Aug 25, 2014 1:44 pm ] |
| Post subject: | Re: HP 3PAR VSS Provider |
Physical servers or virtual? |
|
| Author: | nsnidanko [ Mon Aug 25, 2014 2:02 pm ] |
| Post subject: | Re: HP 3PAR VSS Provider |
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: #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. |
|
| Author: | Cleanur [ Tue Aug 26, 2014 5:08 am ] |
| Post subject: | Re: HP 3PAR VSS Provider |
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. |
|
| Author: | hdtvguy [ Tue Aug 26, 2014 5:46 am ] |
| Post subject: | Re: HP 3PAR VSS Provider |
I am not a fan of 3par's Recovery Manager products, but they make a RM-SQL that may help you out with this. |
|
| Author: | nsnidanko [ Tue Aug 26, 2014 7:57 am ] |
| Post subject: | Re: HP 3PAR VSS Provider |
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. |
|
| Author: | RitonLaBevue [ Tue Aug 26, 2014 2:49 pm ] |
| Post subject: | Re: HP 3PAR VSS Provider |
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 ? |
|
| Author: | nsnidanko [ Tue Aug 26, 2014 3:56 pm ] |
| Post subject: | Re: HP 3PAR VSS Provider |
Here's what I am referring to with RM-SQL: 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. |
|
| Author: | hdtvguy [ Wed Aug 27, 2014 6:01 am ] |
| Post subject: | Re: HP 3PAR VSS Provider |
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. |
|
| Author: | nsnidanko [ Wed Aug 27, 2014 8:21 am ] |
| Post subject: | Re: HP 3PAR VSS Provider |
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. |
|
| Page 1 of 2 | All times are UTC - 5 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|