Hi guys.
We are in the phase of implementing TSM DP For SQL.
We are trying to create FULL-backup-sql.bat and DIFF-backup-sql.bat.
So far we are at creating FULL-backup script and got stucked on "inactivating" databases.
The idea is to make full backup on sunday's and differential backups between monday and saturday.
When we run full backup we would also like to delete any previous full backups (for example: delete full backups older then 1 day)
Currently the script for full backup looks like this:
set TSMERROR=0
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
cd %sql_dir%
CALL %sql_dir%\tdpsqlc backup "Analysis Repository" full /SQLSERVER=srvname /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlschedFULL.log >> %sql_dir%\sqlschedFULL.log
CALL %sql_dir%\tdpsqlc inactiv "Analysis Repository" full /FROMSQLSERVer=srvname /olderthan=0 >> %sql_dir%\sqlschedFULL.log
CALL %sql_dir%\tdpsqlc delete backup "Analysis Repository" full /FROMSQLSERVer=srvname >> %sql_dir%\sqlschedFULL.log
The thing is that inactiv command does not do anything.
It gives error: FMY5551I There are no backups matching the criteria specified for server name
* Please advise us how to achieve to delete full backups older then one day
* My next question is Will the logs be automatically truncated or do we need to "push" them also with tdpsqlc command?
With best regards
We are in the phase of implementing TSM DP For SQL.
We are trying to create FULL-backup-sql.bat and DIFF-backup-sql.bat.
So far we are at creating FULL-backup script and got stucked on "inactivating" databases.
The idea is to make full backup on sunday's and differential backups between monday and saturday.
When we run full backup we would also like to delete any previous full backups (for example: delete full backups older then 1 day)
Currently the script for full backup looks like this:
set TSMERROR=0
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
cd %sql_dir%
CALL %sql_dir%\tdpsqlc backup "Analysis Repository" full /SQLSERVER=srvname /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlschedFULL.log >> %sql_dir%\sqlschedFULL.log
CALL %sql_dir%\tdpsqlc inactiv "Analysis Repository" full /FROMSQLSERVer=srvname /olderthan=0 >> %sql_dir%\sqlschedFULL.log
CALL %sql_dir%\tdpsqlc delete backup "Analysis Repository" full /FROMSQLSERVer=srvname >> %sql_dir%\sqlschedFULL.log
The thing is that inactiv command does not do anything.
It gives error: FMY5551I There are no backups matching the criteria specified for server name
* Please advise us how to achieve to delete full backups older then one day
* My next question is Will the logs be automatically truncated or do we need to "push" them also with tdpsqlc command?
With best regards