I think so (not being an SQL guru I'm now sure what "shrink" means exactly.)

Look at the TDP for SQL book, there are some parms you can add after the
backup * full that determines whether the log is reset or not.


> We currently perform SQL database backups using TDP (using the tdpsqlc
> backup * full command)
>
>
>
> We then use Enterprise Manager to run a log backup (using the BACKUP LOG
> command) followed by a log shrink job (using the DBCC SHRINKFILE
> command)
>
>
>
> Is there a way to do all of these within TDP for SQL?
>
>
>
> Regards
>
> Paul
>
>
>
>
>
> Paul Dudley
>
> ANL IT Operations Dept.
>
> ANL Container Line
>
> pdudley AT anl.com DOT au
>
> 03-9257-0603
>
> http://www.anl.com.au
>
>
>
>
>
>
>
>
>
>
>
> ANL - CELEBRATING 50 YEARS
>
> ANL DISCLAIMER
> This e-mail and any file attached is confidential, and intended solely to
> the named addressees. Any unauthorised dissemination or use is strictly
> prohibited. If you received this e-mail in error, please immediately
> notify the sender by return e-mail from your system. Please do not copy,
> use or make reference to it for any purpose, or disclose its contents to
> any person.
>