I have a SQL Server database where the log file is massive and keeps growing every day.
I've archived data from the database and then done a full backup. I was expecting the log to then be basically "empty". e.g. It might be the same physical size, but now have lots of free space. However, it's currently only got 0.1% free.
Any ideas why there is still almost no free space in the log?