working with huge transaction logs
There will be twice a year that we run an automated process in a very short period of time that will generate a huge transaction log due to the tasks we have to do with the database. How would this effect the log ship if we were to set up a schedule that runs on an hourly basis?
What is the best approach to handle this? What is the best practice? The size of the transaction log could get to a few GBs.