Im having one site collection with 5 sub sites utilizing very high space on the content database. Is it possible to move these sites by creating new site collections to different content databases? Will this lead to any design related issues since the master page is same for all the sites?
You can do it with using the export and import Sp-web
- Export the subsite using export-spweb
- create a new content Database
- Create a new site collection with blank template
New-SPSite http:///sites/test -OwnerAlias "DOMAIN\JDoe" -ContentDatabase WSS_New_Site
- Now import the subsite on that new site collection using Import-Spweb
- Now test.
Keep in mind there are limitation in export/import operation.
Easy method is use the 3rd party tools then move the subsites to new site collections. You can try Sharegate or metalogix etc.(both offer free trial)
Your in-box options are using
Import-SPWeb. However, those options are not full fidelity and do not support sites with Publishing features enabled.
I would instead look at 3rd party solutions. Or reconsider... how large is the database and what is the concern? Out of disk space on the SQL Server?