How can we set maximum MSSQL database size limit?


Staff member
You can follow below steps to set the database size limit using SQL Management Studio.
  • Login to your SQL Management Studio.
  • Right click on particular database and choose “Properties” option.
  • A new dialogue will open where you have to choose “Files” option.
  • You have to click on three dots which is under “Autogrowth / maxsize”.
  • A new dialogue box will open “Change Autogrowth”.
  • Check the box “Enable Autogrowth” option, set the maximum database size according to your need.