>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

Hi Vince,

Can you change the database recovery model to SIMPLE before running DTS and restoring it to FULL after?