Posted by Erland Sommarskog on 07/19/06 21:30

laststubborn (arafatsalih@gmail.com) writes:
> What do you think is it good or bad to remove the second log file ?
> what would you do keep the log file or delete it? Is it gonna have any
> negative effect on my log back and its size?


The main reason for having multiple log files is to spread the load
over disks. Or handle the situation when the transaction log outgrows
its disk.

The log backup will not be very much affected of whether there are one or
two log files. The size of the log backup will depend on much is written
to the transaction log.

I can't really say whether you should keep the second log file, because
I don't know what your database is about, nor do I know the sizes of the
database or the log. But if the log grew, because you failed to back it
up, there is a fair chance that you by now have an over-dimensioned log.


--
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

[Back to original message]