Data Backup and Recovery

SnapCenter SQL Plug In Backup Type

TMADOCTHOMAS
4,125 Views

Hello,

 

I am just testing the SnapCenter SQL Plug-In and preparing to migrate from SnapManager for SQL. The link below describes the three backup types, however to me the documentation doesn't really clarify what they mean practically speaking.

 

I want to replicate what we do in SnapManager which is a full nightly backup and tlog backups every 15 minutes. My guess is that I should schedule a nightly Full backup and log backup (to get a full + tlog) and then a Transaction log backup every 15 minutes. From what I can tell, the tlog backup job doesn't have a retention setting. Does it look at the Full backup and log backup job for the retention?

 

Also: is the simplest way to do this to make the SQL instance the lone resource of a resource group, and then apply both backup types to the resource group?

 

Lastly, I would assume that Full database backup is simply a full backup without a tlog backup. However, the description in the link below seems to indicate it is actually a system database backup only. If that is accurate, would I then schedule this type of backup separately?

 

Would love any feedback or assistance on this as I find the options very confusing.

 

http://docs.netapp.com/ocsc-40/index.jsp?topic=%2Fcom.netapp.doc.ocsc-con%2FGUID-454D4292-3ACB-4258-8D0F-FE99C269A3DD.html

4 REPLIES 4

TMADOCTHOMAS
3,822 Views

FYI for anyone who finds this topic, apparently documentation was just poorly worded. Full + Log and a separate Log job are exactly what we needed. The Full is simply a full backup without tlog backups.

CSCOTTENO
3,658 Views

Found your post.  Thanks!  We had the same question about the "Log Backup" option and the absence of the word "Truncate" in the documentation.

mrahul
3,571 Views

Log snapshot retention is possible via PS cmdlet

 

Ex:

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

 

OR

Set-SmPolicy -PolicyName 'policy' -PolicyType Backup -PluginPolicyType "SCSQL" -DeleteLogFolderSnapshotInExcess 2 -sqlbackuptype 'fullbackupandlogbackup'

 

Please see https://mysupport.netapp.com//NOW/cgi-bin/bol?Type=Detail&Display=1194546

TMADOCTHOMAS
3,560 Views

Thanks @mrahul . Regarding the bug you linked to, is this still an issue? When I set up policies, my understanding was that log backups get set in the main backup policy, and I set them to 1 day there. We did testing awhile back but I didn't specifically test retention, so I don't know if that setting works or not. If not, good to know there's an alternative approach.

Public