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
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