SharePoint 2007 Site collections restore to different databases. RRS feed

  • Question

  • Hi, in my SharePoint 2007 environment one database contains three site collections.

    I want to restore each site collections in separate databases means one database contains only one site collection.

    How to do it because each site collections size is more than 100 GB so I can’t use STSADM command.

    Please tell me how to achieve it.  

    • Moved by Emir Liu Wednesday, May 1, 2013 1:12 AM
    Tuesday, April 30, 2013 5:09 PM


  • Hi,

    You can move the sites using backup command. Though the official limit for this command is 15 GB (Ref :technet ) we have tried it successfully for around 150Gb in our dev environment.

    If your SQL box is strong enough then this approach can work.


    Tuesday, May 7, 2013 12:01 PM