When a database is created, the default size of the database is 2MB and log is 1MB. Under the full recovery model, I know that the transactional backing up of the log only removes the unused part of the log but the log size remains unchanged. So over a period of very active growth the log can exceed the size of the database. The log now has 99% of unused space. So assuming you have hourly transactional log backups the size of the log continues to grow with more and more unused space.
How does Red Gate recommend to get the log back to 1MB?!!!!!!
Is there a solution with each hourly backup job? What other options are there? dbcc shrinkfile