Creating a Site Collection in a New Content Database

Team,

I am looking to see whether we can create new site collections using SPA with an option to specifying a new content database. If you don't know already, a SharePoint Web Application can span multiple Content Databases, the limitation is at the Site Collection level.  Why this is an important concept is because of the fact that a single Content Database for a SharePoint Solution is not ideal, as the size can get very large quickly, and there is no easy way to move content out of a Content Database.

So typically I use the command line to acheive this .

 stsadm -o createsiteinnewdb -url http://docs.companyabc.com/dept/hr -owneremail eval(unescape('%64%6f%63%75%6d%65%6e%74%2e%77%72%69%74%65%28%27%3c%61%20%68%72%65%66%3d%22%6d%61%69%6c%74%6f%3a%53%68%61%72%65%50%6f%69%6e%74%40%63%6f%6d%70%61%6e%79%61%62%63%2e%63%6f%6d%22%3e%53%68%61%72%65%50%6f%69%6e%74%40%63%6f%6d%70%61%6e%79%61%62%63%2e%63%6f%6d%3c%2f%61%3e%27%29%3b')) SharePoint@companyabc.com -ownerlogin COMPANYABC\SPAdmin -sitetemplate sts -title “Human Resources” -databaseserver SERVER1 -databasename HR-Content-DB

 

Is there an option or parameter that can be included to allow the new site collection to be created in a new content database?

Denzil Fernandes
TDBFG

www.td.com
Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Matthew McBride

    Awesome this is a really powerfull option.

     

    Denzil Fernandes
    TDBFG

    www.td.com
  • 0
    Avatar
    Matthew McBride

    Yes, the Site Provisioning Assistant (SPA) tool can create site collection in a new content database.

    1. From the Provisioning Management site, click Site Actions -> Provisioning Settings -> Add Site Collection Provisioning Profile
    2. In the location page of the Add Profile Wizard, select Create In New Content Database
    3. Enter Content Database attributes
    4. Finsih Wizard
    Jeremy Luerkens
    Manager, Software Production
    SharePoint Solutions
Please sign in to leave a comment.