Can I run all my SQL backups from one server?

[osi9400]

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:

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?

 

[moon-buddy]

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:

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?

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.