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" <[email protected]> To: [email protected] 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
