topic Re: Protection Manager and SnapManager for SQL in ONTAP Discussions

Protection Manager and SnapManager for SQL

erick_moore — Thu, 05 Jun 2025 07:20:25 GMT

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?

Re: Protection Manager and SnapManager for SQL

prasads — Mon, 14 Dec 2009 18:08:16 GMT

Hi Erick,

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

Regards,

Prasad

Re: Protection Manager and SnapManager for SQL

erick_moore — Mon, 14 Dec 2009 19:14:46 GMT

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?

Re: Protection Manager and SnapManager for SQL

bmorse — Mon, 14 Dec 2009 20:58:02 GMT

Do you have a SM license?

Re: Protection Manager and SnapManager for SQL

erick_moore — Mon, 14 Dec 2009 21:01:22 GMT

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.

Re: Protection Manager and SnapManager for SQL

bmorse — Mon, 14 Dec 2009 21:38:54 GMT

Erick,

AFAIK, PM only supports SnapVault relationships or "Remote Backups".

Re: Protection Manager and SnapManager for SQL

ianaforbes — Tue, 09 Mar 2010 19:14:49 GMT

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?