Truncate option on TSM

• bala2

  SSCertifiable

  Points: 5547

  More actions

  January 26, 2014 at 8:31 am

  #287729

  Hi,

  We have TSM sql backups configured on our prod server.I have one doubt about Truncate options that configured on the TSM software for

  Log transaction backup.

  start /b /wait tdpsqlc backup * log /TRUNCATE=No /tsmoptfile=xxxxxxxx_log.opt /logfile=log\xxxxxxxxxxx_log.log /configfile=xxxxxxxx.cfg

  Here the Truncate Log value is NO.

  Any idea why the Truncated Log is No? What is the deafult option and which one is preferable on production server(YES or NO).

  2014.01.24 13:14:51 ============== Log file pruned using log retention period of 60 day(s)

  2014.01.24 13:14:51 ============== 4 out of 4 entries pruned from the top of this log

  2014.01.24 13:14:51 =========================================================================

  2014.01.24 13:14:52 =========================================================================

  2014.01.24 13:14:52 Request : LOG BACKUP

  2014.01.24 13:14:52 Database Input List : *

  2014.01.24 13:14:52 Group Input List : -

  2014.01.24 13:14:52 File Input List : -

  2014.01.24 13:14:52 Number of Buffers : 3

  2014.01.24 13:14:52 Buffer Size : 1024

  2014.01.24 13:14:52 Number of SQL Buffers : 0

  2014.01.24 13:14:52 SQL Buffer Size : 1024

  2014.01.24 13:14:52 Number of Stripes specified : 1

  2014.01.24 13:14:52 Estimate : 0

  2014.01.24 13:14:52 Truncate Log? : No ----------------------------------------------

  2014.01.24 13:14:52 Wait for Tape Mounts? : Yes

  2014.01.24 13:14:52 TSM Options File : xxxxxxxxxxxxxxxxxx

  2014.01.24 13:14:52 TSM Nodename Override : -

  2014.01.24 13:14:52 Sqlserver : xxxxxxxxxxxxxxxxx

  2014.01.24 13:14:52

  2014.01.24 14:53:57 Total SQL backups selected: 19

  2014.01.24 14:53:57 Total SQL backups attempted: 12

  2014.01.24 14:53:57 Total SQL backups completed: 12

  2014.01.24 14:53:57 Total SQL backups excluded: 7

  2014.01.24 14:53:57 Throughput rate: 10221.04 Kb/Sec

  2014.01.24 14:53:57 Total bytes transferred: 100,640,634,176

  2014.01.24 14:53:57 Elapsed processing time: 1009.53 Secs

  Advance Thanks for reply.

• peterjonk

  SSCommitted

  Points: 1655

  More actions

  January 26, 2014 at 2:09 pm

  #1683389

  I don't know TSM software. Is this some 3rd party backup software? LOG truncation is an essential feature. Without truncation your LOG files would keep on growing even if a LOG backup is taken filling up your storage eventually. This is the only case I know when LOG truncation is not desired.

  If you are unable to back up the tail of the log using the NO_TRUNCATE option when the database is damaged

  Check for example the SQL Profiler to see which BACKUP LOG command is executed. The NO_TRUNCATE option should not be used.

  __________________
  MS-SQL / SSIS / SSRS junkie
  Visit my blog at dba60k.net

• bala2

  SSCertifiable

  Points: 5547

  More actions

  January 27, 2014 at 1:51 am

  #1683444

  Hi,

  Yes TSM is 3rd party backup tool .

  if we keep Truncate value Yes then i guess log backup chain will be broken..and we will not able to restore in sequence when required.

  Please suggest.

• homebrew01

  SSC Guru

  Points: 55549

  More actions

  January 27, 2014 at 4:59 am

  #1683487

  Can you contact TSM support ??