I have a few Azure PaaS SQL databases that I use mainly for archiving, and they aren't likely to get much read or write activity. Currently, we have around 500GB allocated, but we're only using about 60GB. I've heard that shrinking databases isn't well-supported in Azure PaaS. Is there any other way to reduce the size of these databases?
3 Answers
You can shrink your databases, but be aware that it’s a pretty slow process and only works in a single-threaded manner. If you have some time to spare, I’d recommend exporting your data and re-importing it into a new database instead. That might be a more efficient solution for you.
What kind of licensing model are you using for your Azure setup? It can influence how you manage storage and performance.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures