>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
Vince,
Check this link
http://msdn.microsoft.com/en-us/library/ms345583.aspxfrom this thread (same topic as yours)
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/a6826b29-4ae4-440c-b317-f38b3bac1741
If it's not broken, fix it until it is.
My Blog