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@VM.MARIST.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
