Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14217 reviews 1686 hosting providers

Questions & Answers

Limit MySQL size using Plesk

Mar 25, 2012 by GeekNew
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 votes
Mar 25, 2012 by SmartHost
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