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?

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

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

• Edited by Ninja Warrior 23 hours 52 minutes ago

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