1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

TDPSQL meta object backup to disk pool and multiple management classes??

Discussion in 'Microsoft SQL Server' started by shadab, Feb 11, 2018 at 8:59 AM.

  1. shadab

    shadab ADSM.ORG Member

    Joined:
    Jun 17, 2007
    Messages:
    27
    Likes Received:
    0
    I am stuck in TDPSQL Configuration. currently, we add SQL server which I need to configure for backup.
    my tdpsql on windows 2012 and tdpsql v 6.3 with ba client v 6.3.
    iam trying to use lagacy backup method for backup and restore.

    My requirement is :
    1. Need to take daily full backup for 6 days with retention of 07 days.
    2. Need to take weekly full backup and keep it for 02 months retention.
    3. Nedd to take Monthly full backup and keep it for 02 years retention.
    4. very Importantly i need to bind my meta object to different management class to send backup to disk pool. (documents says tdpsql.opt but dont know how to add the lines)
    i don't know how and in which file bind it .... can anyone answer on these pls.


    I did normal configuration with single management class for daily full backup. rest of the configuration I stuck.

    pls reply.
    SS.
     
  2.  
  3. Trident

    Trident TSM noob with 10 years expirience ADSM.ORG Moderator

    Joined:
    Apr 2, 2007
    Messages:
    365
    Likes Received:
    35
    Occupation:
    IT operations
    Location:
    Oslo, Norway
  4. shadab

    shadab ADSM.ORG Member

    Joined:
    Jun 17, 2007
    Messages:
    27
    Likes Received:
    0
    Thanks alots trident.

    as per i understand "you said to split data and meta data" i need to put the management class entry in tdpsql.opt file.


    just one more question, as per my configuration, iam register three nodes for daily weekly and monthly backups policies for tdpsql with 3 mgmt classes for data and 3 mgmt classes for meta.(the meta and respective data mgmt has same vere value).

    iam going to create 3 tdpsql.opt files for daily weekly and monthly backup policies.

    Do i required to make 3 tdpsql.cfg files also? if yes what should be the changes should I put in different tdpsql.cfg files and how should i assign or bind these .cfg for each different backup respectively? for example (tdpsql_daily.opt + tdpsql_daily.cfg , tdpsql_weekly.opt + tdpsql_weekly.cfg)
     
  5. Trident

    Trident TSM noob with 10 years expirience ADSM.ORG Moderator

    Joined:
    Apr 2, 2007
    Messages:
    365
    Likes Received:
    35
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    Hi,

    Without going down to the nitty gritty cli stuff

    define dom mssql_[daily|week|month]
    define mg data
    define mg meta
    define copy data ....ret=7
    define copy meta ....ret=7
    assign def mgmt data

    Repeat for week and month.


    Make 3 opt files,

    daily.opt

    Connectivity and such stuff

    include \...\meta\...\* meta
    include \...\data\...\* data
    compression no
    alwaycompress no


    wek.opt
    ...

    month.opt
    ...


    You should not need to make three tdpsql.cfg's
    Add sqlcompression yes to this file (if using non dedup pools)
     
    shadab likes this.
  6. shadab

    shadab ADSM.ORG Member

    Joined:
    Jun 17, 2007
    Messages:
    27
    Likes Received:
    0
    Wow. thanks alots .... God bless you. Have a good day ahead.
     
  7. shadab

    shadab ADSM.ORG Member

    Joined:
    Jun 17, 2007
    Messages:
    27
    Likes Received:
    0
    Dear , one strange issue,
    i created the things as described above.
    created meta management class as well as data management classes for weekly and monthly.
    activate data mgmt classes in policy set. and keep meta managment class as it is.
    after adding configuration in the tdpsql.opt file, getting below error:

    ANS9989W Management class SQLMETA_W.MC specified on the INCLUDE
    statement in tdpdsm_w.opt at line 71 does not exist.

    i query tsm server and found that my management class policy set status is standard but not showing active.
    should i need to activate it. because in a policy domain only one managment class should be active.

    pls suggest.
     
  8. Trident

    Trident TSM noob with 10 years expirience ADSM.ORG Moderator

    Joined:
    Apr 2, 2007
    Messages:
    365
    Likes Received:
    35
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    Hi,
    Did you run activate policy DOMAIN POLICYSET?
     

Share This Page