My Azure SQL Database says it is using 25Gb but the actual data is less than 10Gb

My database in Azure is currently giving me this info:Screenshot 2026-02-10 at 9.21.45 PM

But the actual data is around 7.4GB (as per the bacpac file size).
Anyway, the size of the LOG seems huge compared to the actual data.
I have the same problem in many other databases in the same Elastic Pool.

What should I do to correctly shrink the databases, right now I’m constantly increasing the size of the Elastic Pool and that is not economically maintainable, I used to be able to shrink everything just fine when I had my DBs in a SQL Server mnaged on-prem, but here on Azure shrinking seems to not take any actual effect?

Thanks!

Read more here: Source link