Even if SharePoint 2013 hype is all around us, and we love<\/strong> to play with SP 2013 \u2013 let\u2019s be realistic, our daily bread is still with our 3 years old friend (or sometimes with even the older ones).<\/p>\n We had a following task (scenario) in the last days: a customer needs automated creation of Site Collections. But, since there is going to be lot<\/strong> of Site Collections, and since total data volume will go up to 20 TB in first 2-3 years, we needed, because of the SharePoint limits<\/a>, to find a clever way of creating and adding new content databases on the fly, and creating new site collection in those databases.<\/p>\n <\/p>\n Basically, we have configured thresholds \u2013 if in the \u201ccurrent\u201d content database there is more than X site collections, or total data volume is over Y bytes, create a new content database, and store all future site collections in that new content database. Until that database also reaches the thresholds, and then\u2026 you get the point. <\/p>\n The following code does the trick. Note: it is recommended to execute it in the farm administrator context.<\/p>\n <\/p>\n In our case, content databases are all ending with the suffix "XZY\u201d, where XYZ is nothing else but counter. E.g. \u201cMyContentDatabase001\u201d, \u201cMyContentDatabase002\u201d, \u201cMyContentDatabase003\u201d\u2026 etc. We search for the database with the highest index, and check it against (previously configured) thresholds.<\/p>\n <\/p>\n After we have checked the database, and decided if we need to create a new one for our site collections, let\u2019s do it if we need to:<\/p>\n <\/p>\n In the code above, you can leave username and password empty, if you want to use windows authentication. Parameters \u201cwarningSiteCollectionNumber\u201d and \u201cmaximumSiteCollectionNumber\u201d define number of site collections when administrator starts to get the warnings, and the maximal number of the site collections for this content database.<\/p>\n <\/p>\n As opposed to the \u201cusual\u201d way of creating site collections (WebApplication.Sites.Add), it is less known that we can create site collection directly from content database, as in this code sample. Since the content database belongs to a web application, it is obvious that the site collection will belong to that same web application. There are more overloads of this method, for example with only one site collection admin. <\/p>\n And that would be all. New site collection is created in a specific content database. On this way, you can control and govern the growth of your content databases, site collections, and all related parameters.<\/p>\n System.InvalidOperationException: Operation is not valid due to the current state of the object<\/p><\/blockquote>\n Oh, yes. We did have another issue. Since this code was executed from a WCF web service, which has it\u2019s own HttpContext (not the SharePoint one!), the code above has crashed each time we did anything with the SPContentDatabase (create, update, whatever\u2026). And if you have HttpContext, SharePoint wants you to have a valid FormDigest control<\/a>, it\u2019s a security check<\/a>. Which, in the WCF code, we obviously do not have.<\/p>\n So, to simulate the situation that we are outside the Sharepoint context (e.g. in a timer job, or in a console application), which would prevent SharePoint from doing a FormDigest check, just set the following piece of code in your WCF service:<\/p>\nStep 1: get the list of the existing content databases<\/h1>\n
\n\/\/ get all content databases\nSPContentDatabaseCollection contentDbs = siteCollection.WebApplication.ContentDatabases;\n<\/pre>\n
Step 2: get the status of the \u201clast\u201d (working) content database (db size, number of site collections)<\/h1>\n
\nbool createNewDb = false;\n\nSPContentDatabase lastDatabase = contentDbs[contentDbs.Count-1];\n\nif (\n lastDatabase.DiskSizeRequired > this.contentDatabaseMaxTresholdSize || \n lastDatabase.Sites.Count >= lastDatabase.MaximumSiteCount\n )\n{\n createNewDb = true;\n}\n<\/pre>\nStep 3: create a new content database<\/h1>\n
\nif (createNewDb)\n contentDatabase = siteCollection.WebApplication.ContentDatabases.Add(\n serverName, \n newDbName, \n username, \n password, \n warningSiteCollectionNumber, \n maximumSiteCollectionsNumber, \n 0);\n \t\t\t\t\t\t\t\t\t\t\n contentDatabase.Update();\n siteCollection.WebApplication.Update();\n}\n<\/pre>\n
Step 4: create the site collection in the database<\/h1>\n
\nnewSite = contentDatabase.Sites.Add(\n newSiteColectionUrl, \n siteCollectionTitle, \n siteCollectionDescription, \n 1033, \n "MyTemplate#0", \n firstAdminLogin, \n firstAdminName, \n firstAdminEmail, \n secondAdminLogin, \n secondAdminName, \n secondAdminEmail);\n\n\/\/ Let's add the upper limit for the site collection\nSPQuota quota = new SPQuota();\nquota.StorageMaximumLevel = maximumBytesForSiteCollection;\nnewSite.Quota = quota;\n\n\/\/ And update the site collection and the content database\nnewSite.RootWeb.Update();\ncontentDatabase.Update();\n<\/pre>\n
\nvar storeContext = HttpContext.Current;\nHttpContext.Current = null;\n\/\/ do your code\nHttpContext.Current = storeContext;\n<\/pre>\n