2009-12-14 09:32 AM
How are most people setting this up? We have Protection Manager, and SnapManager for SQL, however we do not have a SnapVault license. Are most people trying to time their protection manager settings to coincide with SMSQL backups? i.e. You setup a nightly SMSQL backup at 2AM. Do you then manually create a data set that includes all the SQL LUN's for that system, and set it up to snap and mirror to dr (as an example) at 3AM?
2009-12-14 10:08 AM
AFAIK, you have to create a Application Dataset in Protection Manager(PM) from SM SQL.
So whenever SM SQL takes a backup(snapshot), it will register with the PM.
Then as per the protection policy schedule, PM will copy the backup to the secondary storage system.
And yes you can go & edit the policy schedule in PM.
If you manually create a dataset (DS) then I think PM will create local backups on the Primary which may not be application consistent.
This backup might not be good for restoring.
My 2 cents
2009-12-14 11:14 AM
The only option I get for PM in SMSQL is under the "Data Protection" step on the configuration wizard, and that is to setup an Archival Policy. That requires a SV license which we don't have. Is there some other way to do this that I am missing?
2009-12-14 01:01 PM
Sure do. In the SMSQL documentation the only integration I see mentioned is for SnapVault. So does this mean without a SnapVault license I won't get a clean integration? I really don't care to SnapVault this data anyway. I just want to replicate it over the WAN. I can do it manually, I can do it with SMSQL (Update Mirror options), and I can do it with Protection Manager, but the process seems really kludgy if it is relying on me to time my protection based on when I think the SMSQL jobs will finish.
2010-03-09 11:14 AM
PM doesn't support mirroring? I thought I read that it does? I have the same concerns with SME integration. I'd like to be able to use SME and PM to backup AND snapmirror my SME backups. Is this possible?