Data Backup and Recovery Discussions

Highlighted

SnapCenter SQL Plug In Backup Type

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
Highlighted

Re: SnapCenter SQL Plug In Backup Type

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.

Highlighted

Re: SnapCenter SQL Plug In Backup Type

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

Highlighted

Re: SnapCenter SQL Plug In Backup Type

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

Highlighted

Re: SnapCenter SQL Plug In Backup Type

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.

Try the NEW Knowledgebase!
NetApp KB Site
Forums