David, Check this out:
http://www.microsoft.com/sql/techinfo/tips/administration/logfilegrowth.asp Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 04/06/2004 10:40:44 AM: > Can you reference me an MS SQL doc or something on this? My > SQL DBA's are kind of anti-TSM, so I need as much justification > on this as I can get to give to them. > > (If this is the way it works and I dio a FULL daily at 3 am and log > backups every hour, then if they do "reindex" at say midnight, > then log shouldn't grow much before FULL runs at 3am, if I > understand correctly?) > > 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 > [EMAIL PROTECTED] > > > >>> [EMAIL PROTECTED] 04/05/04 05:53PM >>> > I remember having same problem; and yes you are right. > Even if you are doing incremental sql backup; if in between two > incremental backups you run "reindex", next incremental will be > similar in size as full backup. Logically this is still incremental > only it is too big. > We ended up running reindex weekly ( we run daily incremental and weekly full) > > Regards, > > > Joe Crnjanski > Infinity Network Solutions Inc. > Phone: 416-235-0931 x26 > Fax: 416-235-0265 > Web: www.infinitynetwork.com > > > > -----Original Message----- > From: David Longo [mailto:[EMAIL PROTECTED] > Sent: Monday, April 05, 2004 5:38 PM > To: [EMAIL PROTECTED] > Subject: TDP SQL Transaction log not truncating > > > 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 > [EMAIL PROTECTED] > > > ############################################################## > 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. > ############################################################## > > ############################################################## > 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. > ##############################################################
