1

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 '17 at 10:39
2

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 '17 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 '17 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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