I have one Content DB which is of 250 GB. I want to create new DB and re-add to that particular TOP site collection.

This Web application has several content databases, each for its specific top site collection.

I want to create another content DB for that particular top site collection

Any suggestion?

  • Any suggestion please...
    – Neeraj
    Feb 21, 2017 at 10:39

1 Answer 1


In central admin go to Manage Content Databases [http://CentralAdminURL/_admin/CNTDBADM.aspx] and select your Web Application. Click "Add a content database" and fill in the form.

enter image description here

When done, you can move sites from one ContentDB to another by using the following PowerShell script

Move-SPSite http://servername/sites/sitename -DestinationDatabase NewContentDB

See Move-SPSite for more info.

For the record, SharePoint self-balance new sites to try to keep the number of Site Collection equal (by number) when new are created. That means a new ContenDB will get all new Site Collections until the numbers are equal with other Content Databases on the same Web Application.

  • Thanks for quick reply but it has only one Top site collection associated , which i can see from "manage content database" , so i am just wondering which one i can move . it might have subsite to it but don't access as of now . I already created new content DB to this webaplication but as i said earlier there are many top site collection created inside it and each tope site is somehow linked to its individual Content DB, which i cant figure out..... So I want to add new content DB to one with bigger in size...
    – Neeraj
    Feb 20, 2017 at 15:03
  • @Neeraj Then you're in for a bigger rework of your Web Application. You'd need to replace subsites with actual site collections, and that's a much bigger job. But it's doable.
    – Benny Skogberg
    Feb 21, 2017 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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