MOSS 2007 - 200 GB Content Database
Hi AllI have a 200 GB content database with 2 publishing sites occupying 110 GB and 70 GB respectivitely. These 2 sites have numerious sites under them with sub sites.I want to create 2 new content databases one for the 110 GB site and the other for the 70 GB site. Is there a way to migrate the site? I would like to retain the links to the site.Any Suggestions?. Please let me know.
February 2nd, 2010 2:33am

Splitting databases is a little tricky, but not an impossible task. You can keep your URLs as they are and activate a second DB to transfer some of your site collection over to another DB. I would start with these links. http://technet.microsoft.com/en-us/library/cc825782.aspx http://technet.microsoft.com/en-us/library/cc825782.aspx Regards John Timney
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2010 2:43am

Thanks John. I had a look at them. But do they work with a site with 110 GB of data? Also this is just a publishing site within a site collection and not a site collection on it own. Would the steps in the link you provided still work?
February 2nd, 2010 2:59am

Hi,splitting a content database applies for site collections not siteYou can split the database to move the growing site collections to another database or to another server.consider splitting your site collection to be less then 100Gb, otherwise you will have lots of locks in site collection table. The best tools to split site collection and move content across contentDB is The Microsoft SharePoint Administration Toolkit http://www.microsoft.com/downloads/details.aspx?FamilyID=cd2d09a7-1159-4d40-be1c-8efab1345381http://www.microsoft.com/downloads/details.aspx?familyid=BE58D769-2516-43CB-9890-3F79304528FF&displaylang=enBest Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2010 9:54am

If they are not sitting in their own collections then those links would likely not work. Another way may be to perform an export of your site, deletion from your current site collection and reimport. You'd need to create a second DB - set number of sites allowed for each DB to 1 so it didn't chose the existing DB to bring the site into. stsadm -o backup -url url/site/name -filename c:\temp\name.bak stsadm -o deletesite -url url/site/name stsadm -o restore -url url/site/name -filename c:\temp\name.bak I would though consider whether you should create a separate site collection for this, and restore to that instead. Your URL's would be different but its ultimately more manageable. Regards John Timney
February 2nd, 2010 1:31pm

Thanks Ahmed. But the problem is that I have one site collection with content database of size abt 200GB. I dont have multiple site collections within the main site collection. How would I split that?
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2010 7:44pm

Hi,as you mentioned, that you have one site collectionthen you need to split your sites, and subsites to 2 or 3 site collections, depends on size of your sitesto do this you can use Microsoft SharePoint Administration Toolkit http://www.microsoft.com/downloads/details.aspx?FamilyID=cd2d09a7-1159-4d40-be1c-8efab1345381http://www.microsoft.com/downloads/details.aspx?familyid=BE58D769-2516-43CB-9890-3F79304528FF&displaylang=enor yo may check others trials to do the same issues- http://stsadm.blogspot.com/2007/09/convert-sub-site-to-site-collection.html- http://www.ofonesandzeros.com/2009/09/23/migrating-subsites-to-new-site-collections/- http://blogs.technet.com/corybu/archive/2007/06/21/sharepoint-site-migration-and-balancing-growth.aspxthe last one shows you how to have more than one content database under the same web application,but you need to move site collection rather than site or subsiteso you need first to move subsite to a new site collectionhope this clearBest Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
February 3rd, 2010 2:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics