none
How to restore existing SharePoint site collection on same farm.

    Question

  • Hi, I need to restore existing MOSS 2007 site collection of size 500 GB on same farm and I am using database backup and restore method on the same SQL server, below are the steps I have taken.

    1.Taken SQL backup of existing database “WSS_content_HR” database (and URL is http://myworld:81)

    2.Restored backup on new Database “WSS_Content_AdminHR” on the same SQL Server.

    3.Created new webapplication “myworld:123” .

    4.Run the below STSADM command to attach new database “WSS_Content_AdminHR” on the SharePoint farm:

    stsadm.exe -o addcontentdb -url "http:// myworld:123" -assignnewdatabaseid -databasename " WSS_Content_AdminHR " -databaseserver "MOSSDatabase\MOSS_03"

    Now “WSS_Content_AdminHR” database showing in Central Administration site under Content Database section under “http:// myworld:123” web application BUT the site collection is not showing in Central Administration site under Site Collection List.

    Kindly help what I have to do now?

    Saturday, October 05, 2013 9:58 AM

Answers

  • Hi,

    It iwll not be possible to create a duplicate site collection using Content Database backup method. This is because when you restore the content database backup on another empty database the site collection ID remains the same.

    Because of this, even if you add the new restored content database both the content databases will have the same site collection ID in them and that is the reason why the central admin shows only one site collection.

    To solve this, you will have to do use the stsadm or powershell backup and restore commands for restoring a copy of the same site collection in the same farm. Please find below the links for the same.

    http://www.bradleyschacht.com/backup-and-restore-sharepoint-2010-site-collection-with-powershell/

    Hope this helps!!

    Regards,

    Sharath


    sharath kumart shivarama

    Saturday, October 05, 2013 10:19 AM
  • Hi Pankaj If you restore the content database in same farm then you need to assign new ID to DB which you have done , now you will be able to restore same DB but this scenario will result in orphaned sites if any sites exist in DB . Possible solution: 1. You can plan to remove old content DB 2. Instead of restoring content database again, you can plan to extend same web application , in his case there will be one DB but you will have 2 web apps link to it , you can pan to use different security on each web app. Because the siZe of site is 500gb so site back up and restore might be challenge in your case


    Saturday, October 05, 2013 11:05 AM
  • There doesn't seem to be a reason that you couldn't do a site collection backup/restore through STSADM , although it may take it's time considering it's Content DB is 500gb
    Sunday, October 06, 2013 4:49 AM

All replies

  • Hi,

    It iwll not be possible to create a duplicate site collection using Content Database backup method. This is because when you restore the content database backup on another empty database the site collection ID remains the same.

    Because of this, even if you add the new restored content database both the content databases will have the same site collection ID in them and that is the reason why the central admin shows only one site collection.

    To solve this, you will have to do use the stsadm or powershell backup and restore commands for restoring a copy of the same site collection in the same farm. Please find below the links for the same.

    http://www.bradleyschacht.com/backup-and-restore-sharepoint-2010-site-collection-with-powershell/

    Hope this helps!!

    Regards,

    Sharath


    sharath kumart shivarama

    Saturday, October 05, 2013 10:19 AM
  • Hi Pankaj If you restore the content database in same farm then you need to assign new ID to DB which you have done , now you will be able to restore same DB but this scenario will result in orphaned sites if any sites exist in DB . Possible solution: 1. You can plan to remove old content DB 2. Instead of restoring content database again, you can plan to extend same web application , in his case there will be one DB but you will have 2 web apps link to it , you can pan to use different security on each web app. Because the siZe of site is 500gb so site back up and restore might be challenge in your case


    Saturday, October 05, 2013 11:05 AM
  • There doesn't seem to be a reason that you couldn't do a site collection backup/restore through STSADM , although it may take it's time considering it's Content DB is 500gb
    Sunday, October 06, 2013 4:49 AM