SQL Server Log File Size Management
Posted
by Rob
on Server Fault
See other posts from Server Fault
or by Rob
Published on 2010-04-15T12:29:54Z
Indexed on
2010/04/15
12:33 UTC
Read the original article
Hit count: 392
I have all my databases in full recovery and have the log backups happening every 15 minutes so my log files are usually pretty small. question is if there is a nightly operation that causes lots of transactions to happen and causes my log files to grow, should i shrink them back down afterward?
Does having a gigantic log file negatively affect the database performance? Disk space isn't an issue at this time.
© Server Fault or respective owner