• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDPSQL Daily full backup keeps only 02 versions

shadab

ADSM.ORG Member
#1
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,
 

shadab

ADSM.ORG Member
#3
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

ADSM.ORG Member
#6
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
 

RajeshR

ADSM.ORG Member
#8
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

ADSM.ORG Member
#9
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

ADSM.ORG Member
#10
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

ADSM.ORG Member
#11
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

ADSM.ORG Member
#12
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
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 12 15.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 48 63.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.8%
  • Other (please comement)

    Votes: 7 9.2%

Forum statistics

Threads
31,351
Messages
133,538
Members
21,475
Latest member
sag
Top