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
