IBM Storage Defender

IBM Storage Defender

Early threat detection and secure data recovery

 View Only
Back to discussions
Expand all | Collapse all

How to Backup SQL DB from TDP For different mgmtclass

  • 1.  How to Backup SQL DB from TDP For different mgmtclass

    Posted Fri August 11, 2017 11:26 PM

    Hello Guys,

    I have setup a 2 different node for SQL DB backup TDP is already setup and backup is working fine for 7 days retention now i wanted to use different management class for different node which has a 31 days retention. here is the details below.

    Node Name-

    DCPRCBSDBS01_SQL Domain SQLDOM 7 days retention stgpool - DYGENLTOPP01

    DCPRCBSDBS01_SQLWK Domain SQLDOM 31 days retention Stgpool -WKGENLTOPP01

     

    Command to take backup of SQLDB below.

    @ECHO OFF
    set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
    set sql_log=c:\MSSQL_LOGS
    C:
    cd %sql_dir%
    date /t < NUL >> %sql_dir%\sqlsched.log
    time /t < NUL >> %sql_dir%\sqlsched.log

    %sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log

    set RC=%ERRORLEVEL%
    echo --------------------- >> %sql_dir%\sqlsched.log
    echo Return code was %RC%  >> %sql_dir%\sqlsched.log
    echo ===================== >> %sql_dir%\sqlsched.log
    exit %RC%

    MGMTClass - backup0007 (7 Days Retention)

    MGMTClass - Backup0031 (31 days Retention)

    7 days retention schedule is running daily and 31 days schedule will run weekly already setup, now i have to just setup the management class backup0031, I am failing to understand how to use that.

    OPT-


    COMMMETHOD        TCPip
    TCPSERVERADDRESS      10.101.7.25
    TCPCLIENTPort        1500
    HTTPPORT 1581
    COMPRESSION        no
    CHANGINGRETRIES        2
    *INCLEXCL         "c:\Program Files\Tivoli\TSM\tdpsql\inclexcl"
    MAXCMDRETRIES        4
    RETRYPERIOD        5
    SCHEDLOGNAME        "c:\Program Files\Tivoli\TSM\tdpsql\sched.sql.log"
    ERRORLOGNAME        "c:\Program Files\Tivoli\TSM\tdpsql\error.sql.log"
    QUERYSCHEDPERIOD     2
    SCHEDMODE        polling
    PASSWORDACCESS        GENERATE
    SCHEDLOGRETENTION    30 D
    ERRORLOGRETENTION    30 D
    LARGECOMMBUFFERS    YES
    RESOURCEUTILIZATION    2
    TXNBYTELIMIT        2097152
    TCPWINDOWSIZE        1024    
    TCPBUFFSIZE        512     * 32    * max 512
    Tcpnodelay        yes
    NODENAME        dcprcbsdbs01_sql
    TCPCLIENTADDRESS 10.101.7.21
    TCPPort                 1500
    ENABLELANFREE           Yes
    LANFREECommmethod       tcpip
    lanfreetcpserveraddress 10.101.7.21
    SCHEDMODe               Polling
    REVOKEREMOTEACCESS ACCESS
    MANAGEDSERVICES WEBCLIENT
    HTTPPORT 1581

     

    Prem