I am fairly new to DB management. One of the things I have to work with is a
DTS Package that simply copies a database. One thing that I have noticed is
that every time this runs the transaction log increases and doesn't seem to
clean itself out even when I shrink the database. Is there something missing
in the DTS that should drop the transaction log? The Transaction Log is
currently 103 GB and the data is only .5 GB. Any insight will be greatly
appreciated.

Rob

Wow.

What recovery model are you using ?
Do you ever backup the log?


http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE


"Rob" <Rob (AT) discussions (DOT) microsoft.com> wrote