Could be a setting within sql maybe?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Tuesday, August 01, 2006 1:20 PM
To: ADSM-L@VM.MARIST.EDU
Subject: TDP for MS-SQL retention
Can someone explain why our M$-SQL TDP
Can someone explain why our M$-SQL TDP backups are not following the
management class retention ?
I am getting complaints that the backups are rolling off much too quickly
and we aren't keeping the proper amount of versions.
The MC is setup as VERSIONS EXIST= NOLIMIT and RETAIN ONLY=30, yet we
Zoltan,
What is the RETEXTRA setting?
You should have something like this:
VEREXISTS NOLIMIT
VEREXISTS NOLIMIT
RETEXTRA 30
RETONLY 30
This will keep all inactive backups for 30 days.
Also.. if the management class is not the default,
make sure you have coded the INCLUDE statements
by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
08/01/2006 01:41 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] TDP for MS-SQL retention
Zoltan,
What is the RETEXTRA setting?
You should have something like