Re: TDP for MS-SQL retention
My error in my email:
Yes, this is not the default MC, but the default MC is:
I will double check on the DSM.OPT !
Del Hoobler <hoobler AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/01/2006 01:41 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
ADSM-L AT VM.MARIST DOT EDU
Re: [ADSM-L] TDP for MS-SQL retention
What is the RETEXTRA setting?
You should have something like this:
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
correctly in the DSM.OPT for DP for SQL.
INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass_diskonly_30DAYS
INCLUDE "\...\data\...\*" SqlDbDataMgmtClass_disktape_30DAYS
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/01/2006
> 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
> and we aren't keeping the proper amount of versions.
> The MC is setup as VERSIONS EXIST= NOLIMIT and RETAIN ONLY=30, yet we
> only seeing 3-versions of the backups at any given time.
> Any thoughts ?
> I believe the TDP is at the latest, 5.2(3).1 and the client is higher.