I have TSM server 4.2.3.4 on AIX and two clients each running W2K, SP2.
The two clients have SQL server and I use TDP SQL for hot backups
and do log backups of one of the DB's every hour or two. A FULL
backup of all DB's is done once a day. I use the sqlfull.smp script
with minimum change for our environment. Basically:
tdpsql backup dbname log ......
DBA reports that at sporadic times, the log is not truncating after the
log backup and therefore transaction log is getting big. I see no
errors in tdpsql logs. Only event DBA could reference to is that
problem seems to happen after a "reindex" but not always.
I know that "/Truncate" is the default, but I actually added this parameter
to the SQL 2000 system and still has problem at times.
Versions of two systems:
1. SQL 7.0 SP3; TSM BA 4.2.1.20; TDP SQL 2.2.0.01
2. SQL 2000 SP3a; TSM BA 5.1.5.0; TDP SQL 5.1.5.0
I have checked Tivoli site and not found anything.
Any ideas?
Thanks,
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5509
david.longo AT health-first DOT org
##############################################################
This message is for the named person's use only. It may
contain confidential, proprietary, or legally privileged
information. No confidentiality or privilege is waived or
lost by any mistransmission. If you receive this message
in error, please immediately delete it and all copies of it
from your system, destroy any hard copies of it, and notify
the sender. You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient. Health First reserves
the right to monitor all e-mail communications through its
networks. Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of
a particular entity; and (2) the sender is authorized by
the entity to give such views or opinions.
##############################################################
|
