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