1. Home
  2. Support
  3. Legacy
  4. Databases
  5. Changing MSSQL Database Quota
Click here for full details

Changing MSSQL Database Quota

Total quota size is the disk space allocated for the database file and the transaction log file. Database/Transaction Log file quota ratio is the portion of disk space allocated for the database file. If you set the total quota size to 100 MB and the database/transaction log file quota ratio to 40%, then the maximum database file quota is 40 MB and the maximum log file quota is 60 MB. The more dynamic your database is, the bigger transaction log file quota ratio should be.

To change the quota:

1. Navigate to Databases > MSSQL > MSSQL DBs.

2. Click the Edit icon next to the domain that you wish to change the quota for.

3. Click the Edit icon in the Database Quota section.

4. Enter the new database:log ratio and the new quota size you wish to use. Click Submit.

Click here for full details

Classification: Public
Last saved: 2021/11/11 at 14:31 by Jamie