Hi all,
Is there a definitive command for snapshot deletion/retention - we've been struggling with this for awhile now and no combination of the '-D' or '-R' flag seems to do what we'd like it to do.
For most our our SQL servers this isn't a real issue - once every few months we can manually remove old snaps; however we have a server that has a big database and a high-rate of change so we'd like to take snaps more often but lower the retention time - unfortunately as the deletions don't occur we fill the volume fairly quickly.
The string we're using as a SQL 2005 agent job is similar to this -
C:\Program Files\NetApp\SnapManager for SQL Server\SmSqlBi.exe -H "INFSQL1" -D 4 -R -G -S "INFSQL1" -C 8 "ArchiveManager" -Q "INFSQL1" -UM
Has anyone else had similar issues or is there something I'm missing in the command string ?
Alternatively is there a sdcli.exe / smsqlbi.execommand I can schedule to remove x number of old snaps ?
Thanks in advance, Raj.