Data Backup and Recovery

SnapCenter SQL Log Only Backup Retention

AshV

Hi,

 

I have recently noticed the Up to the Minute retention settings on Full backups only apply for "Full Backup" and "Full and Log Backup".

 

We utilise the "Log Backup" policy quite extensively but there doesn't appear to be a way to specify how to delete these log only backups. The default appears to be 7 days, I would like to set this to be 3 days but there doesn't appear to be a way to do this.

 

All of our "Full backup" jobs are set to keep Up to the Minute for the last 3 days, but this isn't deleting the log only snapshots.

 

Am I missing something?

 

Thanks

1 ACCEPTED SOLUTION

mrahul

Hi ,

 

    You can set the Log backup retention via SnapCenter PS cmdlet

 

Set-SmPolicy -PolicyName 'logbkup' -PolicyType Backup -Description 'Log backup Policy' -retentionsettings @{"BackupType"="LOG_SNAPSHOT";"RetentionCount"="3"} -PluginPolicyType "SCSQL" -sqlbackuptype 'logbackup' -CreateLogFolderSnapshot  

View solution in original post

1 REPLY 1

mrahul

Hi ,

 

    You can set the Log backup retention via SnapCenter PS cmdlet

 

Set-SmPolicy -PolicyName 'logbkup' -PolicyType Backup -Description 'Log backup Policy' -retentionsettings @{"BackupType"="LOG_SNAPSHOT";"RetentionCount"="3"} -PluginPolicyType "SCSQL" -sqlbackuptype 'logbackup' -CreateLogFolderSnapshot  

View solution in original post

Announcements
Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public