The retention policy for backups to IBM Tivoli Storage Manager should be
enforced by time period. Take a look at the "Backing up Microsoft SQL
Server with IBM Tivoli Storage Manager" redbook -
http://www.redbooks.ibm.com/abstracts/SG246148.html

You may need to define the copy group with the following parameters:

verexists=nolimit verdeleted=nolimit retextra=30 retonly=90

Regards,

Mark


From:   "Schaub, Steve" <steve_schaub AT BCBST DOT COM>
To:   ADSM-L AT VM.MARIST DOT EDU
Date: 08/18/2009 05:08 AM
Subject:    [ADSM-L] TDP-SQL retention settings for a legacy full/diff
setup



Windows 2003 SQL Server w/TDP 5.5.1.0
TSM Server 5.4.3.2

Can someone shed some light on what would be the correct copygroup settings
for legacy TDP backups of SQLServer databases assuming a schedule of weekly
fulls and daily (some more frequent) where we would want to be able to
recover to any of the full or diff points for a minimum of 14 days?

Right now we have verexist=14 verdel=1 retextra=30 retlast=90, and we
aren't retaining the diffs correctly.  Diffs and fulls are being sent to
the same mgmtclass.

Thanks,

Steve Schaub
Systems Engineer, Windows
BlueCross BlueShield of Tennessee


-----------------------------------------------------
Please see the following link for the BlueCross BlueShield of Tennessee
E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm