Share via

A community member has associated this post with a similar question:
Decrease Elastic Pool Storage

Only moderators can edit this content.

Decrease Elastic Pool Storage

Handian Sudianto 6,706 Reputation points
2024-09-10T00:38:30.9066667+00:00

Hello,

yesterday i add 50GB to the elasticpool due i run out of space, then i truncate some table and the storage used back to normal.

User's image

When i want to decrease the storage to normal (from 250GB to 200GB) i have this error even the total used is only 105GB. Anyone know why?

User's image

and here the database list in the elasticpool

User's image

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sina Salam 26,991 Reputation points Volunteer Moderator
    2024-09-10T10:36:13.53+00:00

    Hello Handian Sudianto,

    Welcome to the Microsoft Q&A and thank you for posting your questions here.

    Regarding your question to decrease Elastic Pool Storage, after the storage went back to normal do you clean up the database?

    I will advise that you should remove unnecessary data, I mean some of your old logs, temporary data, or unused tables and it's better if you can archive old data to another storage solution if necessary and it is not frequently accessed. Then, if reducing storage is not feasible, consider other options such as splitting the databases into multiple elastic pools or using different Azure SQL Database tiers.

    I hope this is helpful! Do not hesitate to let me know if you have any other questions.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

    0 comments