Since i have this problem in a regular basis, i decided to make a simple script to minimize this problem.
Why not address the root of problem ? Is your database autogrowth not tuned ? You need to find out why your transaction log is growing out of control ?
What you are suggesting is not a good practice that you perform on regular basis.
HTH 😀
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂