Posted by Erland Sommarskog on 03/01/06 00:17

Matik (marzec@sauron.xo.pl) writes:
> I've changed to full model (not bulk).
> I'm backuping transaction log each 15 minutes (maybe thats why the used
> space is so small).
> Transaction log backups are aprox. 36MB big. I saw sometimes, its
> around 100MB. But in general, they are not exceeding 36MB.

Seems like you should be able to shrink the log quite a bit. I would
settle for 1GB, although you might be tempted to set it to 500 MB, but
I would not go any lower than this.




--
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: torn page detection and auto shrink: performance?
• Prev in forum: Re: Group By Query Help
• Thread view: Re: torn page detection and auto shrink: performance?

[Reply to this message]