{"id":14,"date":"2007-08-24T11:02:00","date_gmt":"2007-08-24T16:02:00","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=14"},"modified":"2007-11-21T17:36:13","modified_gmt":"2007-11-21T22:36:13","slug":"landing-a-site-collection-in-its-own-content-database","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/","title":{"rendered":"Landing a site collection in its own content database"},"content":{"rendered":"

One of the many advantages of having site collections over just sub sites is that you can create a content database for each site collection. One of the obvious advantages is when backing up or restoring different pieces of your farm that makes it easier to deal with multiple content databases rather than just a giant content database. There are many other advantages that I am not going to write about mainly because it’s been fully documented at TechNet site.<\/p>\n

Unfortunately, there is no a straight way to tell MOSS where you want your site collections to land when you move them around or create new ones. MOSS uses a round-robin algorithm to distribute them evenly in the existing content databases. However, there is a UI trick (also used in SPS2003) which still can be used in MOSS 2007.A few days ago I was going through the same process for a client and I thought that it is not a bad idea to blog it here.<\/p>\n

We were basically moving a site collection from DEV to QA, both environments were 32-bit, same topology and etc. In other words they were identical in many ways.<\/p>\n

DEV :<\/strong><\/p>\n

DEV-1) Run stsadm to back up the site collection
\n stsadm -o backup -url http:\/\/mossdev\/mysitecollecionDev<\/a>\u00a0 -filename c:\\mysitecollecionDev.dat<\/p>\n

DEV-2) Copy DAT file (mysitecollecionDev.dat) to QA<\/p>\n

QA:<\/strong><\/p>\n

QA-1) Choose between QA-1-1 or QA-1-2<\/p>\n

QA-1-1) ARE YOU MOVING IT TO AN EXISTING WEB APPLICATION?<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1) Go to content databases in central admin
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2) Choose your web application name from the drop down box
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3) Take all existing content databases offline (status=offline).
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 This doesn’t actually take the Site Collections offline, but only prevents any new SiteCollections from being created in these database and that’s\u00a0exactly what we want.
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4) Go to QA-2<\/p>\n

QA-1-2) ARE YOU MOVING IT TO A NEW WEB APPLICATION?<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 1) Create a new web application
\n \u00a0\u00a0\u00a0\u00a0\u00a0 2) Go to QA-2<\/p><\/blockquote>\n

QA-2)Create mysitecollecionQA as an “Explicit Inclusion”\u00a0 managed path (Central Administration–> Application Management–> Managed Paths)
\n QA-3)Create a site collection exactly in the same level as it was in DEV. In this example it should be http:\/\/mossdev\/mysitecollecionQA<\/a>. Make sure that\u00a0the name you choose for content database at level is the name you want to keep for ever ,because we are going to overwrite into this content database
\n \u00a0\u00bcbr> QA-4) Run stsadm to restore the datafile you moved earlier<\/p>\n

stsadm -o restore -url\u00a0 http:\/\/mossdev\/mysitecollecionQA<\/a> -filename c:\\mysitecollecionDev.dat\u00a0 -overwrite<\/p>\n

QA-5) Confirm that your new site collection is created in the only online content DB that you just created and change the status for all the other databases back to online.<\/p>\n","protected":false},"excerpt":{"rendered":"

One of the many advantages of having site collections over just sub sites is that you can create a content database for each site collection. One of the obvious advantages is when backing up or restoring different pieces of your farm that makes it easier to deal with multiple content databases rather than just a […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[3],"class_list":["post-14","post","type-post","status-publish","format-standard","hentry","category-moss-2007","tag-moss-2007"],"yoast_head":"\nLanding a site collection in its own content database - Reza Alirezaei's Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"Landing a site collection in its own content database\",\"datePublished\":\"2007-08-24T16:02:00+00:00\",\"dateModified\":\"2007-11-21T22:36:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/\"},\"wordCount\":455,\"commentCount\":0,\"keywords\":[\"MOSS 2007\"],\"articleSection\":[\"MOSS 2007\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/\",\"name\":\"Landing a site collection in its own content database - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"datePublished\":\"2007-08-24T16:02:00+00:00\",\"dateModified\":\"2007-11-21T22:36:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/08\\\/24\\\/landing-a-site-collection-in-its-own-content-database\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Landing a site collection in its own content database - Reza Alirezaei's Blog %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"Landing a site collection in its own content database","datePublished":"2007-08-24T16:02:00+00:00","dateModified":"2007-11-21T22:36:13+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/"},"wordCount":455,"commentCount":0,"keywords":["MOSS 2007"],"articleSection":["MOSS 2007"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/","name":"Landing a site collection in its own content database - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"datePublished":"2007-08-24T16:02:00+00:00","dateModified":"2007-11-21T22:36:13+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2007\/08\/24\/landing-a-site-collection-in-its-own-content-database\/"]}]},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/14\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}