@Oury Ba-MSFT Please let me know, if you have any suggestions on the abouve
Azure MI: Release unused space for Files in quicker way (around 1TB)
There is a huge table around 1TB of space, distributed across multiple file groups under one file group.
Now we have decommission the table as that is no longer needed ( dropped the table using SQL DROP STATEMENT). As the table was distributed under multiple file group, now file group shows free space. Storage Utilization for MI is still not showing the available space, as the space is not released yet from files.
I am trying to use DBCC SHRINKFILE to release unused space, DBCC SHRINKFILE or SHRINK through GUI for individual files is taking too long.
is there a better and quicker way of releasing the unused space, to make it available for Azure MI instance storage ?