I am backing up transaction log every hour. Sometimes log grows to 10GB as there are some heavy transaction flowing thru the system. This happens sometimes so I don't want to schedule a backup every 15/30 min.
Is there a way to carry backup of log and then truncate it once it grows over 2GB. This way I ma making log switch on size dependent than time.