>All,
>
>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?
>
>Any assistance is greately appreciated.
>
>TIA
>Vince

See also Re: Reindex w/o creating transaction log entry Thread #1284039