If a site collection content database size grow up; can I add a second Content Database to it? if No, what's the solution?


A site collection have a single content database, we can't have 2 content database for a single site collection.

Now couple of things you can do.

  • Clean Up, delete all unused files, items etc. Clear the recycle bin.

  • we can also split the site collection into multiple site collections. Like if you have multiple subsites in it than make those subsites a separate site collection n move into different content database.

  • Create a new site collection, move the old data in that site collection.

  • Thank you! please how split the site collection into multiple site collections? How move the old data in that site collection to new one? – Aashirya Jun 7 '17 at 11:59
  • there are couple of ways to move out the data, using 3rd party tool or export the site and import on 2nd site collection or manually copied the content using open with explorer option. I know it is painfull but yes thats the options. BTW how big the content database right now? – Waqas Sarwar MVP Jun 7 '17 at 12:58
  • 1
    that is big enough for a site collection, i would start with clean up process. delete old / unused content. empty recycle bin. BTW site collection size is also 400GB? – Waqas Sarwar MVP Jun 7 '17 at 13:02
  • 1
    go to central admin > application management > Configure quotas and locks...on this page you have to select the site collection to check the quota – Waqas Sarwar MVP Jun 7 '17 at 13:04
  • 1
    You can also see where your data is within the site collection if you go to Site Settings > Storage Metrics. – AM2FTW Jun 7 '17 at 14:55

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.