I have a big content database for a MOSS 2007 site. I want to split it into several content databases based on different departments before migrating to SharePoint 2010. I want to know: Does MOSS 2007 import/export, backup/restore support copying subsite content to a different site collection? Thanks.

You can use the stsadm Backup & restore method to move the site collections into new content DB. Its little tricky but i always use this way. Step One: Take the backup of your site collection (using stsadm -o backup)http://technet.microsoft.com/en-us/library/cc263441(office.12).aspx 2) create a new content DB 3) take offline your existing content Db(which having all site collections) 4) restore the site collection(usisng Stsadm 0o restor)http://technet.microsoft.com/en-us/library/cc262087(office.12).aspx Tip: always use the overwrite parameter because you already have site collections into you Web app. stsadm -o restore -url <URL name> -filename <file name> -overwrite Once you move the your required number of site collections into new content DB then create another one. took all offline except the new one you just created and again perfom the step 4... Once you done with you move bring online all the content dbs. Hope this help thanks -ws SharePoint administrator, MCTS,MCITP

With MOSS 2007, I don't think you can export at the subsite level (only site collection). Depending on the size and content, you might be able to move the subsites to a different site collection by saving them as site templates (with content), and uploading the templates to the new site collection. By default, the maximum template size is 10mb, which you may need to increase by running the following stsadm command: stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000 The propertyvalue indicates the size in bytes, and must be less than 524288000 (500Mb). If site templates are not an option, you may have to look at recreating/migrating content to a new site collection.

With MOSS 2007, I don't think you can export at the subsite level (only site collection). Depending on the size and content, you might be able to move the subsites to a different site collection by saving them as site templates (with content), and uploading the templates to the new site collection. By default, the maximum template size is 10mb, which you may need to increase by running the following stsadm command: stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000 The propertyvalue indicates the size in bytes, and must be less than 524288000 (500Mb). If site templates are not an option, you may have to look at recreating/migrating content to a new site collection.