TDPSQL Daily full backup keeps only 02 versions

[shadab]

Dear All.

I configured my tdpsql with following details. it's SQL 2014 on windows 2012 with baclient and tdp version 6.4.

Backup type Legacy.
Daily full backup, No logs backups select in backup scripts. pls, note I don't want point-in-time recovery.

Daily full: vere= 8 verd=0 rete=0 reto=0 (wants to keep last 08 days backups)

Weekly Full: vere= 12 verd=0 rete=0 reto=0 (wants to keep last 12 weeks backups)

Monthly Full: vere= 24 verd=0 rete=0 reto=0 (wants to keep last 02 years backups)

I configured it with three different management class and node name for daily weekly and monthly backups.

All daily, weekly and monthly Metadata backed up on the same disk pool and SQL data on tape.

My Daily backup job completed successfully, but when I logged into Gui and go to Restore selecting an active-inactive option, it shows me only last 02 days backups only (one active another inactive).

Should I need to change something on SQL server side also? or else what I miss or where am doing a mistake. pls, suggest.

Thanks,

 

[marclant]

I'm assuming you did more than 2 backups?

Sounds like you followed this: http://www-01.ibm.com/support/docview.wss?uid=swg21624164 , right?

 

[shadab]

Dear Marclant,
First of all rhanks for reply.

I did whats there in the link.
Created 03 diffrent node name for 3 types of backups under 03 diffrent domain, policy group.... My weekly backup shows 1 active backup as just i started tht backup last week only. But 03 daily backups shows only 02 in reatore pane. 1 active and another in active ....

 

[shadab]

I'm assuming you did more than 2 backups?

yeah, Today jobs completed total 05 daily full backups but still showing 02 backups available in the restore.

 

[marclant]

Did you activate the policy(ies) after making updates to the management classes?

 

[shadab]

my configuration steps on TSM server

Daily Backup:

def dom sql.dom
def pol sql.dom standard.pol
DEF MGMT SQL.DOM STANDARD.POL SQL.MC
define copyg sql.dom standard.pol sql.mc standard vere=8 verd=0 rete=0 reto=0 dest=SQL_TP
Assign defmgmt sql.dom standard.pol sql.mc
Activate pol sql.dom standard.pol

MGMT Class For Meta data:
DEF MGMT SQL.DOM STANDARD.POL sqlmeta.MC
Define copyg sql.dom standard.pol sqlmeta.mc standard vere=8 verd=0 rete=0 reto=0 dest=SQL_DP
Activate pol sqlw.dom standard.pol
--------------------------------------------------------------------------------
Weekly Backup:

def dom sqlw.dom
def pol sqlw.dom standard.pol
def mgmt sqlw.dom standard.pol sqlw.mc
Define copyg sqlw.dom standard.pol sqlw.mc standard vere=12 verd=0 rete=0 reto=0 dest=SQL_TP
Assign defmgmt sqlw.dom standard.pol sqlw.mc
Activate pol sqlw.dom standard.pol


MGMT Class For Meta data:
DEF MGMT sqlw.dom STANDARD.POL sqlmeta_w.mc
Define copyg sqlw.dom standard.pol sqlmeta_w.mc standard vere=12 verd=0 rete=0 reto=0 dest=SQL_DP
Activate pol sqlw.dom standard.pol

 

[marclant]

It appears good. I'm not familiar enough with SQL, not sure if there is something there to do too.

 

[RajeshR]

Daily full: vere= 8 verd=0 rete=0 reto=0 (wants to keep last 08 days backups)

If you want to keep 8 days backup keep vere=nolimit verd=1 rete=8 retd=(uptoyou)
Note: if you keep vere=nolimit with rete=8 - you will have as many as backups you triggered within 8 days.
For sql retention is must and it's purely managed by TSM server not like rman.

 

[shadab]

Hi Rajesh, I will change the setting and get back to you, thanks for your reply. hop it will solve the issue. even after 06 days daily full backup only 02 backups listed under restore tab (1 is active and another is inactive).

 

[RajeshR]

vere you can keep 8 as well, if you have only one full backup everyday. But if you wish to add more than 1 full backup in a day it should be nomilit, and its better to keep no limit, when you perform a adhoc full sql db backup last 8th day backup still can remain in TSM or in future if you register new sql nodes under same domain with a different requirement it will be useful.
Note: Change retention policy for both disk and tape mgmt classes as same. (meta and data mgmt classes)

 

[shadab]

Tnxs Rajesh:
So my new setting should be:
for db backups:
define copyg sql.dom standard.pol sql.mc standard vere=nolimit verd=1 rete=8 reto=0 dest=SQL_TP

for meta backups:
define copyg sql.dom standard.pol sqlmeta.mc standard vere=nolimit verd=1 rete=8 reto=0 dest=SQL_DP

 

[RajeshR]

Tnxs Rajesh:
So my new setting should be:
for db backups:
define copyg sql.dom standard.pol sql.mc standard vere=nolimit verd=1 rete=8 reto=0 dest=SQL_TP

for meta backups:
define copyg sql.dom standard.pol sqlmeta.mc standard vere=nolimit verd=1 rete=8 reto=0 dest=SQL_DP

Validate and active after updating copygroups.
read about copygroups here, you will understand how many days your required to keep reto, if u have a requirement.
https://www.ibm.com/support/knowled...bm.itsm.srv.doc/r_mplmntpol_retbackpvers.html

 

[shadab]

Thanks, Rajesh, now everything is ok