Kevin,

I can't seem to find where to do this.

Your solution sounds exactly what I am looking for, but I don't see those tables in any of the databases.
thanks

Im sorry, but that is exactly what I am doing and is causing the problems

Below is what I don't understand. I don't have any of those tables. where is the line called config_db.sitemap.

Maybe I am missing something?

Here is the workaround. First find out the Id of the sites (site collection) in the [restored_db].Sites then delete the line in the [Config_db].SiteMap with the same Id. Now attach the content_db and you should see the sites.

Hi, my problem is same as GORDON, I do not know from where to start and where to find those tables and rows,please send me the steps on my email ASAP.

Thanks in advance for your sharing.

MY issue was this. I had to restore some data that was deleted from an existing site a time previous to our deleted retention in sharepoint. I had to restore a backup copy to get that data. I tried to restore the database and site to the same server. I still had the old database connected and tried to restore the recovered database to the same server.

Even if you give it a different name in the tables it is still looking at a unique site id. When you restore a site, it maintains that unique site id. YOU MUST Shut down the original site and disconnect it from the database before you bring up the restored site. Once I did that, it came up with a 1 site found and all was well. I spent many a day to figure that out. No one seemed to be able to give me a good answer on that one until I hit the right person.

I hope this helps!!!

The above solution worked for me. To clarify:
1) restore your content database from the backup file
2) Using SQL Server Management Studio, look in your content database for table Sites and retrieve its data
3) Take note of the Id column value
4) Navigate to your Sharepoint configuration database; typically SharePoint_Config
5) Goto table SiteMap and look for the row with the matching id value.
6) Delete it.
7) Attach your content database to your Site Collection via Central Admin.

hey Gordon,
Unfortunatly I have to to exctly the same thing ... but do not want to put my original site offline ...
Have you fin an other solution ?
Thanks a lot,

Hi Gordon,
Have you find an other solution without put the original site offline ... ?

Thanks,

Hello I did exactly what you said , but when I got to SQL 2005 and look up the ID column in the Sites Table , it read Id(uniqueidentifier,not null) , that was all I saw , I ddont see any value

Can you help me
THanks

Hi , I ve figured it out ,but there is another problem

In the Sites Table , I saw many many Values under ID Column , which one should I pick???
THanks

Hi KB...

Can you please share your solution?

Thanks!

Instead ...remove the previous site and add the same content database to new site it works for me - Sivabalan11@hotmail.com

Hi Marcel,
Can you please elaborate more? I am stuck and not too familar with SQL Server 2008...just basic knowledge.
Additional details in the errro:
Primary key violation on SQL Server instance "tclg-mosstt" in database 'Sharepoint_Config'
Also:
Violation of PRIMARY KEY constraint 'PK_SiteMap'. Cannot insert duplicate key in object 'dbo.SiteMap'.

You can email the information to me.

Greatly appreciated,
Shelley

New infrastructure update from MOSS gives you a new parameter for stsadm called -assignnewdatabaseid...that should fix the problem?