Our sharepoint database is large ~180GB. I want to split it up into smaller database from the disaster recovery point of view & also that it can be easily moved across servers. The problem is that we have a main SharePoint site (only one site collection) and all departments each have their own subsites underneath the main site. This was done a long time back.
What is the best way to move these subsites into their own content databases? I want to keep the URLs the same (e.g) http://sharepointserver/HumanResource
I have seen some articles which sort of tell that sitecollections can only be split into different content databases and not the site or subsites. They have also indicated the work around to convert these subsite into individual site collections for having a individual database.
These things sort of point me in the direction i want to go, but no direct conclusive answer.
Any help is much appreciated.