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.
edit: Using SQL 2005 will be using 2k8 soon. (I thought i put it in... d'oh)