In SharePoint 2007 content databases can grow till 100 GB. What if you want to move your existing sites to a new content db?
Well, Here is the manual way to move site collection to a different database in SharePoint 2007:
- Backup and Delete the Site Collection
- Set all your Content Databases' maximum allowed sites to the number of current sites.
- Set the Content Database you want the Site Collection to go into to allow one more Site Collection.
- Restore the Site Collection
- Adjust your Content Database maximums to allow new sites to be created.
You need to know your source DB, where your site resides first. How do we know what is the content db for a particular site collection? well, you can retrieve that information by running the stsadm command. Here is the command:
stsadm -o enumsites -url http://webapp_host_header > c:\sites.xml
Now, we've got and decided our source and destination DB's. ready to move the site? Here you go
stsadm -o mergecontentdbs -url http://web_App_URL -sourcedatabasename <Source DB Name> -destinationdatabasename <Destination_DB> -operation 3 -filename c:\output.xml
Move site collection to another content database in SharePoint 2010 / SharePoint 2013 using PowerShell:
Move site collection to another database in SharePoint 2010-2013, you can use the PowerShell cmdLet- Move-SpSite
Another nice way to move SharePoint Site collections between Content Databases: Use SharePoint Admin Tool kit - http://www.microsoft.com/downloads/details.aspx?familyid=BE58D769-2516-43CB-9890-3F79304528FF
It provides central Administration UI to move SharePoint site collection from one database to another
In case, you want to move the sites between Farms, You will have to backup/restore or export\import to move site collections.
Technet article on mergecontentdbs: http://technet.microsoft.com/en-us/library/cc262923%28office.12%29.aspx
You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.