Can't find a solution? Call Digiweb support on 1918



Changing MS SQL 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, do the following:

  1. Select MS SQL DBs in the Databases menu.
  2. On the page that appears click the name of an existing database.
  3. On the form that shows, click the Change quota icon against the Database quota field.
  4. Enter new database log file ratio and total quota size on the next page:

  5. Click Submit.
  6. Agree to additional charges if any.


Related Articles

No related articles were found.

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
30th of January, 2009

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

No users have voted.

How would you rate this answer?




Thank you for rating this answer.

Continue