When I perform regular 2 hourly transaction log backup,the size of the log does not get truncated automatically.
How can I ensure that TLog files get truncated after each transaction log backup?
DB is hosted in SQL 2008 Ent edtion.
Set-up 2 hourly backup starting at 7 am till 11.59PM and full backup at 1 Am every day.
Thanks and regards.