Azure sql server managed instance data size

sakuraime 2,326 Reputation points
2021-01-04T05:38:19.127+00:00

53068-capture.png

the diagram says max database size 4TB for business critical and 8TB general purpose (which surprise me why general purpose get larger database size). ...

53098-capture2.png

the follow capture said 30% add for log file .

so the max size of the database ( the actual data ) is 8TB - 8TB x30 % ????

or 4TB - 8TB* 30%??

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,336 Reputation points
    2021-01-04T12:45:10.51+00:00

    @sakuraime 30% additional storage is added to accommodate for the growth in LDF files.

    Your max data size is still 4TB or 8TB.
    You should not factor in this additional storage while calculating your database size requirement.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.