Hi Paul,

Data Protection for SQL can certainly run LOG backups.

You could modify your automated scheduled batch file
to call the a SQL Server job to shrink the files.
For example, something like this:

   tdpsqlc backup * full
   tdpsqlc backup * log
   osql -E -i shinkjob.sql

where "shinkjob.sql" is a TSQL command file to
shrink the log for you.

Thanks,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/02/2007
11:56:00 PM:

> We currently perform MS 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