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.
