Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Content Database Questions

  Asked By: Katie    Date: Dec 12    Category: Sharepoint    Views: 1107

I am implementing a WSS site provisioning process including locking down all my content databases using quotas and limits. I am trying to prevent ANY of our content databases from growing beyond 25GB and I want strict control over all WSS sites provisioned.

So... For my Finance Portal I have the following Content databases:

Database Name Database Status Current # of Sites Site Level Warning Max # of Sites
Finance_FREE_10MB_SITE Offline 0 2000 2500
Finance_PREMIUM_825MB_SITE Offline 0 24 30
Finance_STANDARD_350MB_SITE Offline 0 56 70
FinanceP1_SITE Offline 2 9000 15000
Finance_HUGE_2000MB_SITE Offline 0 9 12

Basically my plan to acheive this is that I am going to leave all databases "OFF". When a site needs created, it will be analyzed and created within one of my databases (depending on the projected scale of the site). When the site is created, it will be applied a "Quota Template" that is appropriate for each database that will ensure me my databases cannot grow beyond 25GB. In my head, I am thinking that this will all work... But I have a few questions:

With this, I have the following questions:

Question#1: I plan on keeping all databases Offline and "manually" turning the "appropriate" database online when it comes time to provision a site. Are there any drawbacks to this? I want to ensure that "sites" already existing are still able to add content and sub-sites even though the database is off. (I have tested this minimally and it seems to work).

Question#2: Theorhetically speaking, if all of my databases above were in the "ONLINE" state and I were to create a new WSS site. Where would it go?

Question#3: Is there any other operation, task, job that will be unable to run if all the content databases are set "Offline"? Something I missed?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Darrius Whitfield     Answered On: Dec 12

See my inline...

I am implementing  a WSS site  provisioning process  including locking  down
all my content  databases using quotas  and limits. I am trying to
prevent ANY of our content databases  from growing  beyond 25GB and I want
strict control  over all WSS sites  provisioned.

So... For my Finance Portal I have the following Content databases:

Database Name Database
Status Current # of Sites Site Level Warning Max #
of Sites
Finance_FREE_10MB_SITE Offline
0 2000
2500
Finance_PREMIUM_825MB_SITE Offline
0 24
30
Finance_STANDARD_350MB_SITE Offline
0 56
70
FinanceP1_SITE Offline
2 9000
15000
Finance_HUGE_2000MB_SITE Offline
0 9
12

Basically my plan to acheive this is that I am going to leave all
databases "OFF". When a site needs created, it will be analyzed and
created within one of my databases (depending on the projected scale of
the site). When the site is created, it will be applied a "Quota
Template" that is appropriate for each database  that will ensure me my
databases cannot grow beyond 25GB. In my head, I am thinking that this
will all work... But I have a few questions:

With this, I have the following questions:

Question#1: I plan on keeping all databases Offline and "manually"
turning the "appropriate" database online when it comes time to
provision a site. Are there any drawbacks to this? I want to ensure
that "sites" already existing are still able to add content and
sub-sites even though the database is off. (I have tested this
minimally and it seems to work).
[Reply] I've heard of other people taking this approach successfully.

Question#2: Theorhetically speaking, if all of my databases above were
in the "ONLINE" state and I were to create a new WSS site. Where would
it go?
[Reply] The least busy database. Unfortunately, least busy is determined
by the number of Site Collections, not Site Collection size.

Question#3: Is there any other operation, task, job that will be unable
to run if all the content databases are set "Offline"? Something I
missed?
[Reply] I don't know, sorry.

 
Didn't find what you were looking for? Find more on Content Database Questions Or get search suggestion and latest updates.




Tagged: