Re: [ADSM-L] Backup strategy for SQL server.
2010-10-26 06:06:19
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
>
>
|
|
|