January 26, 2014 at 8:31 am
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.
January 26, 2014 at 2:09 pm
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
January 27, 2014 at 1:51 am
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.
January 27, 2014 at 4:59 am
Can you contact TSM support ??
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply