Limit MySQL size using Plesk

727 views
asked Mar 25, 2012 in Database by GeekNew (720 points)
hello there

I want to limit the MS SQL databases size to 150 MB noting that these databases are created in a Windows server and I am using Plesk. How can I set the limit in MS SQL database globally so that database can’t exceed the size limit?

can anyone help please

1 Answer

0 like 0 dislike
answered Mar 25, 2012 by SmartHost (9,060 points)
Hi

As you have Plesk control panel on your server hence you can restrict database size from Plesk itself.
In Plesk, click on Limit for the domain that has the database then enter necessary size in "Microsoft SQL database quota" box  at top for "Overuse policy", make sure you select "Overuse is not allowed" so that whenever account overuse the limits, it will be suspended by Plesk.

Hope this helps
...