As a fairly new DBA, I have a question for the experts out there. We have a database transaction log file that grew to a whopping 425 GB because no transaction log backups were taking place (the db backup plan is set to full recovery mode.) I have since remedied the problem, and the t-logs are being backed up regularly now. The backups are all coming in at around 6.5 GB, but the original log file is still 425 GB.
Obviously, we need to shrink the size of the original file. I have read a lot of comments about how shrinking the file could cause performance problems, so before I shrink it, I wanted to ask if there are any hidden repercussions I need to be aware of.
Any advice would be greatly appreciated.