NetApp Community Update
This site will enter Read Only mode on July 23 as we prepare to move to a new platform. You will still be able to view content, but posting and replying will be temporarily disabled.
We're excited to launch our new Community experience on July 30 and more information will follow soon.
Stay connected during the transition - Join our Discord community today.

Data Protection

SC with SMSQL SnapVault Retention

REISTTELECOM
3,256 Views

Hello community,

after finally being able to configure Snap Creator to make backups of our SQL server, I now have the problem, that on the secondary storage, only one copy is retained.

I already read, that the SnapVault settings within SC are overwritten by SM settings. Is this true?

Therefor I tried to figure out how to set retention for the secondary within SM commandline.

Current SMSQL setting: -svr 'LXBI-DWHDB10\SWISSDWH' -RetainBackupDays 7 -RetainShareBackups 7 -lb -bksif -RetainSnapofSnapInfo 7 -rudays 7 -mgmt daily -GenericNaming

Any suggestions or ideas?

BR Stephan

1 REPLY 1

clilescapario
3,256 Views

Hi Stephan,

I have not tried the native support for SV, but I do have SC setup w/ SMSQL and PM. SC will kick SMSQL to take the application consistent snapshot, and then register these snapshots in PM. SC then pokes PM to start the SV transfer. When the transfer is complete, PM then vaults the application consistent snapshot that is created by SC and will keep it for the retention configured in the PM policy.

When doing a config this way, SMSQL knows nothing about the secondary protection, so the SMSQL command line is configured just like a "local-only" protection would be.

Hope that helps you and good luck,

Chris

Public