Hi david,
  Thank you for your answers.

Regards,
 
Rajesh 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
ADSM-L
Sent: Monday, October 25, 2010 4:08 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Backup strategy for SQL server.

Try this:

> Versions Data Deleted: NOLIMIT


This, in collaboration with your RETO and RETE settings of 30 days,
should ensure your inactivated objects remain available for restore for
the 30 days you require.

Rgds,
________
David Mc
London

On 25 Oct 2010, at 08:56, "Lakshminarayanan, Rajesh"
<Rajesh.Lakshminarayanan AT DFS DOT COM> wrote:

> Hi ,
> 
> 
> 
>    I recently implemented the following backup strategy to backup one
> of the sql server to TSM through TDP.
> 
> 
> 
>    Backup strategy (full + log+ differential):
> 
>      Sun  --> Full + log backup (full backup is followed by
transaction
> log backup and truncate the log).  I just backup the transaction log
> just to truncate it after full backup.
> 
>      Mon - Sat --> Diffull (differential backup).
> 
> 
> 
>    I follow same management class for all the sql backup (full,
> incremental & log).   Below is my backup copy group details attached
to
> this node. 
> 
> 
> 
>        Versions Data Exists: no -limit
> 
>        Versions Data Deleted: 1
> 
>        Retain Extra Versions: 30                  
> 
>        Retain Only Version: 30
> 
> 
> 
>    At any point of time I want to retains only last 30 days of sql
> backup (full, incremental & log) in the tsm.  
> 
> 
> 
>    Issue encountered:
> 
> 
> 
>      The diffull backup gets inactivated and expired after full backup
> is performed on the sql server. I am not sure what is causing the
difful
> copy to get inactivated and expire after full backup is completed.
Can
> some one tell me why my differential backup is not following the
> retention policy.  Should I need to change any thing my configuration
> for this backup strategy.
> 
> 
> 
>   My Server & client Configuration: 
> 
> 
> 
>    Server : Version 5, Release 4, Level 1.2 
> 
>    OS   : AIX 6.1 TL5
> 
> 
> 
>    TDP Client:
> 
> 
> 
>     OS: Windows 2003 R2 standard x64 edition (SP2)
> 
>     SQL version: SQL server 2005 (64-bit) 
> 
>     Tsm client Api: 5.5.3
> 
>     TSM TDP version: 5.5.0.0 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Regards,
> 
> 
> 
> Rajesh Lakshminarayanan
> 
> Tel: +65 6416-2257
> 
> HP: +65 9159-8117
> 
>