Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

Configuring Site Collection Quotas and Locks

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

If you are using Microsoft in a large environment, such as at an Internet Service Provider (ISP) or in a large intranet, you need to be able to maintain control over your server resources and carefully monitor areas such as storage space and site security. You must be able to ensure that one site collection cannot use so many resources that other site collections can no longer function. allows you to specify quota for site collections, so that you can manage your site and server resources. You can set quota limits for the following items:

  • Storage

    When you set a quota limit for storage, you can set two values: a warning value and a maximum value. When a site collection passes the warning limit, an e-mail message is sent to the site administrator and owner notifying them that their site collection is near to their storage quota. E-mail messages are sent daily until the storage level drops below the warning level. When a site collection meets the maximum limit, another e-mail message is sent to the owner and administrator, and no new content can be added to the site collection. Note that before e-mail messages can be sent, you must configure the e-mail server settings and be running the Microsoft SharePoint Timer service. For more information, see Configuring E-Mail Settings and Scheduling Timed Jobs .

    Note: The size of the data reported by quotas does not necessarily match the size of the storage in the database. This is because the quota feature estimates storage figures for empty sites in the site collection (sites that contain no user content) and includes those figures in the quota, as well as the actual storage from the database. The estimated size of an empty site includes the real size of the template pages for , such as the forms pages and pages in the _layouts directory, which are not normally counted, since there is only one copy of these pages for all sites. Although each site has a unique URL to the pages, the site does not have a unique instance of the page.

  • Users

    In Active Directory account creation mode, you have the ability to limit the number of users that are added to Microsoft Active Directory directory service from any single SharePoint site collection. When you set a quota for user accounts, you specify a maximum limit only. When the maximum number of users for a site collection has been reached, no additional user accounts can be added unless one or more user accounts are deleted from the site collection.

You can create multiple sets of quotas, called quota template, and use them in different areas or your server farm, or to suit different users. For example, in an ISP setting, you could have the following quota templates:

  • FreeApplied to free or demo site collections, restricts users to 10 MB of storage and five users.

  • StandardApplied to monthly-fee site collections, allows site owners up to 25 MB of storage and 50 registered users.

  • PremiumApplied to extranet site collections for large corporate customers, allows organizations up to 10 GB of storage and unlimited user accounts.

You must be an administrator of the local server computer or a member of the SharePoint administrators group to be able to manage quotas and quota templates.

Enabling Quotas

The quota feature is disabled by default in there are no default quota values or templates. To enable quotas, you use the following methods:

  • To use quotas for your server or server farm, you create a quota template.

  • To use quotas for a particular virtual server, you assign a default quota template to that virtual server.

  • To use quotas for a particular site collection, you assign a quota template to the site collection when you create the site collection.

  • To use a set of quota values for a single site collection only, you can apply specific quota limits to the site collection itself, independent of any quota template.

You can reverse your decision to use quotas at any point in the hierarchy. For example, applying a default quota template to a virtual server does not mean that all site collections under that virtual server must use the quota limits it only means that they can. Settings that you apply to a single site collection can be cleared if you no longer want to use quotas.

About Quota Templates

Quota templates and the settings specified in them are stored in the configuration database for your server or server farm. Quota values apply to site collections and are applied when you create a site collection. You can specify a default template to use for all site collections created on a virtual server, for example, or you can specify the template to use when you create the site collection. The values listed in the quota template are copied into the database for the site collection and are referenced from there.

If you change the values for a quota template, those changes apply only to new site collections created by using that template, not to existing site collections. To update the quota values for large numbers of existing site collections, you can use the object model or an SQL query. For details on using the object model, see the SPSite object in the . You can run queries similar to the following against your content databases to update quota values:

  • To update the storage quota:

    Update sites set diskquota=<new storage amount> where <search criteria>
    
  • To update the number of users quota:

    Update sites set userquota=<new # users limit> where <search criteria>
    

    For the where <search criteria> clause, it is recommended that you use "QuotaTemplateId=<ID for the modified quota template>". To find a quota template ID, check the database for a site collection that uses the quota template, and then make a note of the template ID. You can also use the current value for the diskquota or userquota to locate the site collections that need to be updated; however, this method does not restrict the update to site collections based on the changed quota template.

To update all site collections that use a quota template, you must run the query for all content databases in the server farm.

When you delete a quota template, the template is removed from the configuration database, but any site collections created using that template retain the quota values. If you want to remove quotas from all site collections using a particular quota template, you must use the object model or perform an SQL query. For more information about using the object model, see the .

Managing Quota Templates

You manage quota templates from the SharePoint Central Administration pages for your server or server farm. You can create or delete templates or change the values in the templates.

Create a quota template

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage Quota Templates .

  4. On the Manage Quota Templates page, in the Template name area, select Create a new quota template .

  5. In the Template to start from box, select a template to base your new template on.

  6. In the New template name box, type the name to use for your new quota template.

  7. In the Storage Limit Values section, select the Limit site storage to a maximum of: ___ MB check box, and then type the amount of storage to allow at a maximum.

  8. Select the Send warning e-mail when site storage reaches ___ MB check box, and then type the amount of storage to allow before sending a warning e-mail message.

  9. In the Invited User Limits section, select the Limit invited users to a maximum of: ___ users , and then type the number of users to allow.

    Note: The user limit option is available only in Active Directory account creation mode.

  10. Click OK .

    When you click OK , the new template is added to the list of available templates, and the page is refreshed.

You can delete a quota template if you change your quota structures. However, remember that deleting a quota template will not delete quota values from site collections that were created using the quota template. If you want to remove quotas from all site collections using a particular quota template, you must use the object model or perform a SQL query.

Delete a quota template

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage Quota Templates .

  4. On the Manage Quota Templates page, in the Template name area, select Edit an existing template .

  5. In the Template to modify box, select the quota template you want to delete.

  6. Click Delete .

    When you click OK , the template is removed from the list of available templates, and the page is refreshed.

You can change individual quota values in a template. The new values apply only to new site collections created using the quota template. The changed values are not applied to existing site collections unless you use the object model to update the values in the database.

Change an existing quota template

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage Quota Templates .

  4. On the Manage Quota Templates page, in the Template name area, select Edit an existing template .

  5. In the Template to modify box, select the quota template you want to change.

  6. Update the options you want to change, and then click OK .

    When you click OK , the template is updated, and the page is refreshed.

Specifying a Quota Template for a Virtual Server

When you extend a new virtual server, you can specify a quota template to use as the default quota template for that virtual server on the Extend and Create Content Database page. Any new site collections that you create under the virtual server will automatically use the values in the default quota template. You can change the default quota template for a virtual server from the Virtual Server Settings page. Keep in mind that changing the default quota template does not change quota values for existing site collections. Only newly created site collections will use the new quota template.

Change the default quota template for a virtual server

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Virtual Server Configuration , click Configure virtual server settings .

  3. On the Virtual Server List page, select the name of the virtual server you want to change.

  4. Under Virtual Server Management , click Virtual server general settings .

  5. In the Default Quota Template section, select the quota template to use as the default template when new site collections are created.

  6. Click OK .

Specifying Quota Values for a Specific Site Collection

If you want to specify a different set of limits for a particular site collection, you can do so. Specifying quota values for a single site collection is an easy way to turn on quotas on a site collection basis. Similarly, if you need to make an exception to a quota template for a particular site collection, you can change the quota value for just that site collection. Keep in mind, however, that it is possible to lock a site collection simply by changing the quota value. If you already have quotas set for a particular site collection, and want to update the value, be sure to check the site collection's current quota levels before making the change. For example, suppose the current quota level for site storage is 25 MB, and a site collection has 21 MB. If you change the value to 20 MB, the site collection will be locked as soon as you save the change. To prevent locking a site collection accidentally, be sure to check the current storage or invited user count for the site collection before making a change to the quota values.

If you do not know what the existing quota values are for a site collection, you can use the SharePoint Central Administration page to view the current values and the current data (storage used and number of users) for the site collection.

View current quota values and data for a site collection

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage site collection quotas and locks .

  4. In the Select a Top-level Web Site section, type the URL in the Enter the top-level Web site URL box, and then click View Data .

  5. In the Site Quota Information section, view the settings listed to see the quota settings and current values.

To view the current data for a site collection, you can also use the Site Collection Usage Summary page for the top-level Web site.

View quota data for a site collection

  1. On the site collection you want to view data for, click Site Settings .

  2. Under Administration , click Go to Site Administration .

  3. Under Site Collection Administration , click View site collection usage summary .

After you have checked the site collection quota data, you can change the quota values for a site collection. Note that this action does not change the quota template, and the change does not affect any site collection except the site collection you specify.

Change quota values for a site collection

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage site collection quotas and locks .

  4. In the URL of Top-level Web Site section, type the URL in the Enter the top-level Web site URL box, and then click View Data .

  5. In the Site Quota Information section, change the Limit storage to a maximum of __ MB amount, Send warning e-mail when site storage reaches __ MB amount, or Limit invited users to a maximum of amount setting.

    Note: The user limit option is available only in Active Directory account creation mode.

  6. Click OK .

Removing Users for Quotas

In Active Directory account creation mode, you can set quota limits for the number of users allowed for a site collection. If this quota is exceeded, no more users can be added to any site within the site collection until a user has been removed from the site collection or the quota limit is changed. To have any effect on the user quota, users must be removed at the site collection level. Removing users from individual sites does not affect the quota, and does not allow you to add more users.

To remove users from a site collection, you use the Manage Site Collection Users page in Site Administration.

To remove site collection users

  1. On the Site Settings page, in the Administration section, click Go to Site Administration .

  2. In the Site Collection Administration section, click View site collection user information .

  3. Click the box next to the users that you want to delete, and then click Remove Selected Users .

    Note: You must be a member of a site group with the Manage Web Site right to perform this action. This right is included by default in the Administrators site group.

Managing Locks

You can use locks to stop site collections from exceeding your storage quota limits, and to block all users from accessing a site collection if necessary. Site collections are locked to block new content automatically when they exceed the maximum storage quota. You can also lock a site collection manually to block all access, if, for example, it is in violation of your site use policies. Depending on the type of lock, the result of a locked site collection is different:

  • When a site collection is locked for exceeding a storage quota limit, users who attempt to upload new content see a disk full error.

  • When a site collection is locked manually to block all access, users who attempt to view a site in the site collection will see an access denied message. When a site collection is locked manually to block new content, users who attempt to add content see a disk full error.

Site collections can be unlocked by different methods, depending on the reason for the lock. Site administrators can unlock site collections by themselves if the site collection is locked for exceeding quota limits. Only a server administrator can clear a manual lock. The following table lists the lock reasons and methods for unlocking site collections.

Lock reason

Server administrator action to unlock

Site administrator action to unlock

Storage limit exceeded

Change the quota value.

Delete excess site content or documents.

Manual lock by server administrator

Clear the Adding content prevented or No access lock.

None.

If you need to lock a site collection and deny all users access to it, either temporarily or permanently, you do so by using the Manage Site Collection Quotas and Locks page.

Lock a site collection manually

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage site collection quotas and locks .

  4. In the URL of Top-level Web Site section, type the URL in the Enter the top-level Web site URL box, and then click View Data .

  5. In the Site Lock Information section, select Adding content prevented or No access .

  6. If you lock a site collection with Adding content prevented or No access , you must type an explanation in the Additional lock information box.

  7. Click OK .

When a site collection has been locked manually, you can unlock it by using the Manage Site Collection Quotas and Locks page.

Unlock a site collection

  1. Click Start , point to All Programs , point to Administrative Tools , and then click SharePoint Central Administration .

  2. On the Central Administration page, under Component Configuration , click Manage quotas and locks .

  3. On the Manage Quotas and Locks page, click Manage site collection quotas and locks .

  4. In the URL of Top-level Web Site section, type the URL in the Enter the top-level Web site URL box, and then click View Data .

  5. In the Site Lock Information section, select Not locked , and then click OK .

Related Topics

Quota data is captured along with the usage analysis data for a site collection. For more information about the usage analysis process, see Configuring Usage Analysis .

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft