SQL Server Log File Size Management
- by Rob
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.