How to restore existing SharePoint site collection on same farm.

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?
LVL 10
Minesh ShahSharePoint & all about itAsked:
Who is Participating?
Mohammed KhawajaConnect With a Mentor Manager - Infrastructure:  Information TechnologyCommented:
Each site collectipn has a unique identifier and you will not be able to restore it in a same farm (ie clone it).   Either you restore to a different farm or restore via STSADM.EXE.  This is a known issue.
Minesh ShahSharePoint & all about itAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.