SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SharePoint Farm in which the main Portal Web Application uses a single WSS_Content database, which has grown a lot to about 150 GB.

I know I can now put it offline and attach a new one, but I wonder if I can migrate existing site collections to shrink the size, and if it's possible for Site Collections in offline databases to still have new subsites added?

share|improve this question
up vote 7 down vote accepted

In SharePoint 2010 you can add additional Content Databases to your Web Application and then use the Move-SPSite PowerShell command to move site collections from one database to the other.

To add a Content Database: Goto Central Admin > Application Management > Manage Content Databases. Select your web application and add a database.

To use the Move-SPSite PowerShell command:

share|improve this answer
Also, if you want to move content within Site Collections (from one Site Collection to another) you would need to to it manually or with third-party migration tools. SharePoint only has the ability to move Site Collections between content databases out-of-the-box. – John Chapman Sep 13 '11 at 14:47
I guess this works provided you have your content split up into manageable site collections but if you've got a really large site collection then you're pretty much out of luck? – pigeon Apr 4 '12 at 3:40
pigeon, that's where third party tools would be needed. – John Chapman Dec 6 '12 at 22:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.