Hi Gary,

How long do you want to keep the older backups on the TSM Server?

Many times I see customers set their policy based on time not versions.
For example, to keep the DP/SQL backups for 3 years:
   VEREXISTS nolimit
   VERDELETED nolimit
   RETEXTRA 1095
   RETONLY 1095

But... it all depends on how long you want to retain them.
... or if you want the old versions to be purged when
the new backup is taken... etc.
You would need to modify the policy settings accordingly.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 03/19/2010
08:57:21 AM:

> [image removed]
>
> Longish term backup of sqlserver db question
>
> Lee, Gary D.
>
> to:
>
> ADSM-L
>
> 03/19/2010 08:58 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> We have a need to back up a single sqlserver database which only
> changes yearly.
> Would like to back up once, then remove from the sqlserver.
> It will then be rebacked up in approximately 1 year.
>
> Been through the tdp for sqlserver manual, but I know little of
sqlserver.
> Is this just a management class issue where verdeleted would be
> somewhat longer than one year, and retextra would be 0?
>
> Gary Lee
> Senior System Programmer
> Ball State University
> phone: 765-285-1310
>
>