ADSM-L

Re: Need help on truncated Sql database

2002-02-07 08:02:18
Subject: Re: Need help on truncated Sql database
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Thu, 7 Feb 2002 07:53:56 -0500
> SQL server 6.5
>
> What parameters must I put into the Tivoli SQL 1.1  bat file so that the
> logs get truncated

Hugo,

For TDP for SQL version 1...
Take a look at Chapter 1 of the User's Guide.
Under section titled "Additional SQL Application Client
Backup Strategy Considerations" it discusses
truncation considerations. If you run a
SQLDSMC /BACKUPINCR:DB1 , it should
truncate the log upon successful backup.

FYI... TDP for SQL is out of service
as of 1/26/2002. I realize you are still
running on SQL 6.5 which is not supported
by TDP for SQL 2.2... but I wanted to
make you aware of it.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"Celebrate we will. Life is short but sweet for certain..."  -- Dave
<Prev in Thread] Current Thread [Next in Thread>