SQL Truncate logs

tsmdumber

ADSM.ORG Member
Joined
Jan 27, 2011
Messages
108
Reaction score
3
Points
0
Hi

I use the command below for scheduled log backup.

%sql_dir%\tdpsqlc backup * log /truncate=yes /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull_logb.log >> %sql_dir%\sqlsched_logb.log

after this command is complete when the sql dba shrinks the logs( from msql 2005
) it doesn't work!!

how ever when log back is manually done using GUI with truncate =yes, the shrinking works from ms sql 2005.

am using 5.5.3.0 and microsoft mssql 2005?

anything am missing?

Regards,
TSMDUMBER
 
This is a shot in the dark from a TSM nube but might it be a permission problem?
Maybe check the user that owns the TSM service that will call the script.
Just a thought.
 
Back
Top