1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Can I run all my SQL backups from one server?

Discussion in 'Microsoft SQL Server' started by osi9400, May 12, 2009.

  1. osi9400

    osi9400 New Member

    Joined:
    Apr 10, 2009
    Messages:
    22
    Likes Received:
    0
    To simply reporting, agent execution etc, I want to run all my SQL Server backups from one SQL Server. I modified my SQLFULL script to backup my SQL Servers as follows:

    Code:
    set tsm_dir=C:\Progra~1\Tivoli\TSM\TDPSql
    set sql_dir=D:\Progra~1\Micros~1\MSSQL.1\MSSQL\Backup
    set opt_path=%tsm_dir%\DSM
     
    date < NUL >> %sql_dir%\sqlsched.log
    time < NUL >> %sql_dir%\sqlsched.log
    %tsm_dir%\tdpsqlc backup * full /tsmnode=SQL1 /tsmp=thldyw41 /tsmoptfile=%opt_path%\SQL1\dsm.opt /logfile=%sql_dir%\sqlfull.log 
    %tsm_dir%\tdpsqlc backup * full /tsmnode=SQL2 /tsmp=thldyw41 /tsmoptfile=%opt_path%\SQL2\dsm.opt /logfile=%sql_dir%\sqlfull.log 
    %tsm_dir%\tdpsqlc backup * full /tsmnode=SQL3 /tsmp=thldyw41 /tsmoptfile=%opt_path%\SQL3\dsm.opt /logfile=%sql_dir%\sqlfull.log 
    
    The problem is that it is NOT backing up all three nodes. It appears to be backing up the host node three times in a row. Can I backup everything from one server?
     
  2.  
  3. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,072
    Likes Received:
    269
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    As far as I know, TDP for SQL is not remote-aware. You need to backup or initiate backup on the node itself.

    This beats going around the licensing issue.
     
: mssql, script, tdpsql

Share This Page