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:
- 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
- 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