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:
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
