Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

SQL retention fails as the UTM setting is lower than the full backup setting

Views:
13
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Server (SC) 4.4
  • SnapCenter Plug-in for Microsoft SQL Server (SCSQL) 4.4
  • Full backup and Up To the Minute (UTM) retention

Issue

  • SC fails to remove both database and Up To the Minute (UTM) snapshots and no error shown in the job logs
  • The <installation_path>\NetApp\SnapCenter\App_Data\log\SnapManagerWeb_<id>.log shows that SC recognizes the snapshot to delete but does not do so:

DEBUG SnapManagerWeb_33027 PID=[14504] TID=[64] Enter GetSnapshotNamesToBeDeleted
DEBUG SnapManagerWeb_33027 PID=[14504] TID=[64] Found 1 entries in database in table nsm_BackupToSnapshot for backupId : <ID_number>
DEBUG SnapManagerWeb_33027 PID=[14504] TID=[64] Found 1 snapshots found in backup component for backupId : <ID_number>
DEBUG SnapManagerWeb_33027 PID=[14504] TID=[64] Snapshot names : <snapshot_name>

It only removes the snapshot from the SnapInfo volume:

DEBUG SnapManagerWeb_33027 PID=[14504] TID=[64] Removed snapshots successfully: <SVM_Name>  -Volume <snapinfo_volume_name>, -Snapshot <snapshot_name>

 

Scan to view the article on your device
CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support