Good day everyone. We have about 45 DBs in our environment and we were doing a full, differential, and log backup using Backup Exec. We had a situation with Backup Exec and we needed to backup using the SQL agent for a bit.
Well, we forgot about backing up the logs since the DBs were in full recovery mode. Now some of the log files are very large. We have since created a maintenance plan to backup the logs and the space used has gone down but the all of the space is still associated with the file.
Is there a simple way I can create a job that will run tonight to shrink all of the log files so they can release the space? If so, what impact will running this have on the SQL environment regarding other processes running at the same time?