Hi,

    I am little bit confused with David's answer.  It would be great if
some one brief's me what is wrong with my setting.

     Version Data deleted will take effect only when the database is
deleted from the server and more over the "version data exists" option
is set to no-limit. Over here I didn't delete the database.   When full
tdp backup is executed after the weekly differential backup, diff copies
get inactivated and it is not available for restore.  Based on my
setting the inactive copies should be available for 30 days.   

My copygroup setting is 

Versions Data Exists: no -limit
Versions Data Deleted: 1
Retain Extra Versions: 30                  
Retain Only Version: 30

Does tdp backup has different interpretation for the above setting?


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
> 
>