locked
Split a content database into serveral pieces RRS feed

  • Question

  • 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.

    • Edited by Mike Walsh FIN Tuesday, November 23, 2010 4:36 PM 2010 question removed. Ask SP 2010 questions in a SP 2010 forum.
    Tuesday, November 23, 2010 4:04 PM

Answers

  • 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
    • Marked as answer by Emir Liu Thursday, December 2, 2010 2:26 AM
    Tuesday, November 23, 2010 4:36 PM
  • 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.

     

    • Edited by Mike Walsh FIN Thursday, November 25, 2010 5:00 PM This is a pre-2010 SP forum. Please restrict your answers to what is the situation with pre-2010 products. 2010 comment removed
    • Marked as answer by Emir Liu Thursday, December 2, 2010 2:26 AM
    Thursday, November 25, 2010 4:37 PM

All replies

  • 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
    • Marked as answer by Emir Liu Thursday, December 2, 2010 2:26 AM
    Tuesday, November 23, 2010 4:36 PM
  • 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.

     

    • Edited by Mike Walsh FIN Thursday, November 25, 2010 5:00 PM This is a pre-2010 SP forum. Please restrict your answers to what is the situation with pre-2010 products. 2010 comment removed
    • Marked as answer by Emir Liu Thursday, December 2, 2010 2:26 AM
    Thursday, November 25, 2010 4:37 PM