SMSQL snapshot policy -RetainSnapofSnapInfoDays

waltere — Thu, 05 Jun 2025 07:15:21 GMT

Posting a question from a partner. Any insight would be appreciated.

Thanks

-Walter Engle

From: Don Mann [mailto:dmann@EPLUS.com]
Sent: Thursday, April 15, 2010 4:07 PM
To: NetApp Partner Service Helpdesk
Subject: SnapManager for SQL snapinfo snapshots

I have my SnapManager for SQL job scheduled to keep 4 days worth of snapinfo (-bksif -RetainSnapofSnapInfoDays 4 –trlog). What I’m seeing is my snapshots are sticking around since I configured the jobs. Here is the full detail of the job:

SMSQLdailyBackup1 SQL Agent Job C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlJobLauncher.exe new-backup –svr 'HOSTBIDB' -d 'HOSTBIDB', '10', 'bo_xi_cms', 'bo_xi_cms_prod', 'di_repo', 'etl_stage', 'master', 'model', 'msdb', 'parameters_bi', 'son_db_bi', 'son_db_bi_v2' -ver –verInst 'HOSTBIDB' -mp –mpdir 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint' -RetainBackupDays 7 -lb -bksif -RetainSnapofSnapInfoDays 4 -trlog –mgmt daily -ArchiveBackup -ArchivedBackupRetention Daily HOSTBIDB 4/14/2010 10:00:00 PM Succeeded 4/15/2010 10:00:00 PM

Volume hostbisnapinfo

working...

%/used %/total date name

---------- ---------- ------------ --------

0% ( 0%) 0% ( 0%) Apr 14 22:02 sqlinfo__hostbidb_04-14-2010_22.01.00__daily

0% ( 0%) 0% ( 0%) Apr 13 22:04 sqlinfo__hostbidb_04-13-2010_22.01.26__daily (snapvault)

0% ( 0%) 0% ( 0%) Apr 12 22:03 sqlinfo__hostbidb_04-12-2010_22.01.14__daily

0% ( 0%) 0% ( 0%) Apr 11 22:02 sqlinfo__hostbidb_04-11-2010_22.00.44__daily

0% ( 0%) 0% ( 0%) Apr 10 22:03 sqlinfo__hostbidb_04-10-2010_22.01.06__weekly

0% ( 0%) 0% ( 0%) Apr 09 22:02 sqlinfo__hostbidb_04-09-2010_22.00.37__daily

0% ( 0%) 0% ( 0%) Apr 08 22:02 sqlinfo__hostbidb_04-08-2010_22.00.34__daily

0% ( 0%) 0% ( 0%) Apr 07 22:00 sqlinfo__hostbidb_04-07-2010_22.00.21__daily

0% ( 0%) 0% ( 0%) Apr 06 22:01 sqlinfo__hostbidb_04-06-2010_22.01.08__daily

1% ( 0%) 0% ( 0%) Apr 05 22:00 sqlinfo__hostbidb_04-05-2010_22.00.21__daily

1% ( 0%) 0% ( 0%) Apr 04 22:00 sqlinfo__hostbidb_04-04-2010_22.00.19__daily

1% ( 0%) 0% ( 0%) Apr 03 22:00 sqlinfo__hostbidb_04-03-2010_22.00.21__weekly

1% ( 0%) 0% ( 0%) Apr 02 22:01 sqlinfo__hostbidb_04-02-2010_22.00.52__daily

1% ( 0%) 0% ( 0%) Apr 01 22:01 sqlinfo__hostbidb_04-01-2010_22.00.44__daily

1% ( 0%) 0% ( 0%) Mar 31 22:01 sqlinfo__hostbidb_03-31-2010_22.00.27__daily

Can anyone tell me what I am missing here? Why is it not deleting the old snaps?

Thanks,

-don

Don Mann

Sr. Solutions Architect

SMSQL snapshot policy -RetainSnapofSnapInfoDays

nimalraj6 — Fri, 27 May 2011 11:43:03 GMT

Is this issue fixed for you. According to NetApp both these bugs are fixed in the latest version of SMSQL (5.1) but I am still seeing this in my environment!?

topic SMSQL snapshot policy -RetainSnapofSnapInfoDays in ONTAP Discussions

SMSQL snapshot policy -RetainSnapofSnapInfoDays

Re: SMSQL snapshot policy -RetainSnapofSnapInfoDays

SMSQL snapshot policy -RetainSnapofSnapInfoDays