Posted by d.grabov on 11/22/06 12:10

Thanks, the article makes some good points, however the log file is
over 30 times bigger than the database and 94% empty, hence the need to
shrink.

Erland Sommarskog wrote:

> (d.grabov@gmail.com) writes:
> > Can anyone offer some advice on how to reduce the size of a database
> > log. The database is mirrored on another server using the logs. Thanks
>
> Read http://www.karaszi.com/SQLServer/info_dont_shrink.asp to find out
> why you maybe shouldn't.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Shrinking database log used for mirroring
• Prev in forum: Re: Severe performance hit with NCHAR queries
• Thread view: Re: Shrinking database log used for mirroring

[Reply to this message]