Why would you want to shrink the log files if the next overnight process will need more space for the logs anyway? You do realize that auto growing files in SQL Server affect performance?
Check also
http://www.sqlskills.com/BLOGS/PAUL/post/Becoming-an-involuntary-DBA-youre-not-alone.aspx>
>I am new to Sql Server and unfortunately (for me) my company does not have a DBA, so I find myself in the dubious position of having to assume most of this responsibility, doing so by the "seat of my pants" so to speak.
>
>We have many overnight procedures that run DTS packages to migrate data into tables on the Server. I have noticed that the Log files have grown rather large in comparison to the actual DB, in some cases 10 to 1 times.
>
>Is there a way for me to automate the shrinking of the Log files after a DTS executes? And have it execute as part of the DTS?
>
--sb--