the log would grow to 30-40gb and then be shrunk to 5gb after the job
Thom, I am not sure I understand why that is a bad thing to do.
Everyone, I could use some help with the following questions:
Why is it bad to shrink the log file?
Why is a log file necessary if I am taking backups of database on a daily or sometimes hourly basis? If there is a crash, I would use the backup as the restore point.
Our log file seems to grow very large, and can easily be shrunk down from over 1GB to about 1000K. I did not think that was a bad thing until I started reading through some of the posts on this thread.
Thanks for all the information everyone is posting. I am learning a lot.
Jarrod