Can we create different database for site collection? In sharepoint for one web application we have one sql server database. Now for different different site collection if i want to create different different database than how can i create that?


You have the following two ways:

  1. Create a new content database in SP Central Admin. Restrict all other Content databases to their maximum site limit. After that you create your new site collection. Or
  2. You can create a new content database and use Move-SPSite Powershell cmdlet for moving existing site collections to various content database. For more information on Move-SPSite check msdn link.

I hope you are using SharePoint 2010 and above.


You can't do that. A site collection can not be split into different content databases. You can put different site collections into different content databases. If you want to Create SharePoint Site Collection In Its Own DB you can use this post.


There is UI way. You can create new content data base from SharePoint Central Administration. Read this blog post.


You can use this link http://www.sharepoint-journey.com/create-sitecollection-specific-content-database.html it may help u

  • 2
    Links are good for reference, but never good when answering questions. Links may break in the future, and if your answer has nothing more than a link it'll be useless. Please revise your answer.
    – Benny Skogberg
    Dec 26 '13 at 6:50
  • I have to do this pro grammatically. How can we do that using code behind from visual studio Dec 27 '13 at 11:03

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.