Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS 2003: Quotas

  Asked By: Amolika    Date: Jan 23    Category: Sharepoint    Views: 1145

By default, each user is only allocated 100MB of space in the portal.
Does anybody know how I can increase this value?

I went in to "Configure site quotas" on the SPS Central Administration
page and removed all limits. But when I view the usage for myself, I'm
still limited to 100MB.

Do I have to do any updates or anything to let the system know that I
made this change?

Any advice?



7 Answers Found

Answer #1    Answered By: Edgardo Atkins     Answered On: Jan 23

After doing some research, I found out that deleting or changing the
quota template does not delete or change the values for sites that were
already created using that quota template. The only way for me to change
the value is to use the object model and perform a SQL Server query.

Now my question is, does anybody know what is the name of the field,
which database and which table this value is stored at in order for me
to do the query? I know by default, the installation of the database
actually installs a total of 4 databases.

Answer #2    Answered By: Kamal Mayachari     Answered On: Jan 23

Interesting, so you can not change a quota? Looking at a Tech Refresh db
diagram, I see in the ...SiteDB database there is a Site table with a
DiskQuotaID and a QuotaTemplateId field. That is where I would start.

Answer #3    Answered By: Kelsie Terrell     Answered On: Jan 23

This is from the admin guide, I am guessing you tried this?

Change quota values for a site

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

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

6. Click OK.

Answer #4    Answered By: Puneet Shiwde     Answered On: Jan 23

Making that change below does not work. From the admin guide, I'm
supposed to use SPSite to make the change. This requires coding which I
have no knowledge of. An excerpt from the Admin guide:

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
Windows SharePoint Services Software Development Kit. You can run
queries similar to the following against your content databases to
update quota values:

I'm having my developer look into this right now.

Answer #5    Answered By: Brandyn Slater     Answered On: Jan 23

I did not see that. I played around with the SDK Code but so far have
been getting permission errors when trying to change the quota. It
appears straight forward other than that. I will probably play with it
more over lunch - let us know if you get the quota's changed using code.

Answer #6    Answered By: Hubert Pollard     Answered On: Jan 23

Actually in your earlier email about going into the Site db worked. I
went in there and modified the DiskQuotaID field to 1000MB and it

Answer #7    Answered By: Gladys Trevino     Answered On: Jan 23

No problem. I get a nervous going to the DB - never know what else if
going on. But if it worked - so be it.

Didn't find what you were looking for? Find more on SPS 2003: Quotas Or get search suggestion and latest updates.