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

• Next in forum: Re: SQL Server 2005 Opening Script File Problem
• Prev in forum: Re: Alter a SQL table
• Thread view: Re: transaction log

[Reply to this message]