Posted by Hugo Kornelis on 08/19/06 21:40

On Sat, 19 Aug 2006 17:46:44 GMT, Charles MacLean wrote:

>How can I truncate and shrink the transaction log under SQL 2000? My log is
>10 GB in size and I assume most of the transactions are committed.
>
>Thanks
>

Hi Charles,

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Hugo Kornelis, SQL Server MVP

[Back to original message]