ONTAP Discussions

SMSQL snapshot policy -RetainSnapofSnapInfoDays

waltere
2,881 Views

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

2 REPLIES 2

nimalraj6
2,881 Views

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!?

Public