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

TDP SQL Server : meta data consideration

Discussion in 'Microsoft SQL Server' started by mroussel, Oct 6, 2015.

  1. mroussel

    mroussel ADSM.ORG Member

    Joined:
    Apr 18, 2007
    Messages:
    11
    Likes Received:
    0
    Occupation:
    TSM & Unix admin
    Location:
    Lyon - France
    Hello

    On the latest versions of TSM for SQL Server (v7.1.3), is there are still restrictions regarding metadata destination? (not on removable storage)

    Many thanks !
     
  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
    Hi,
    You can put it wherevere. But, for restore tasks, it is preferred to have it on disk. It saves you a lot of waiting and fighting for tapes.
     
  4. mroussel

    mroussel ADSM.ORG Member

    Joined:
    Apr 18, 2007
    Messages:
    11
    Likes Received:
    0
    Occupation:
    TSM & Unix admin
    Location:
    Lyon - France
    Thanks !
    So, I will test with a specific management class for metadata (with a dedicated disk stgpool).
    For cons, I have to externalise long terms backups (offsite). I do not know if it is compatible.
     
  5. shadab

    shadab ADSM.ORG Member

    Joined:
    Jun 17, 2007
    Messages:
    27
    Likes Received:
    0
    dear Trident, iam unable to open a new post thats why post my query here , pls look into this....

    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.
     

Share This Page