I need to restore a site "Sales" within same web application. Here is what I did?
- Created a backup of "Sales_DB" using sql management studio. http://intra.df.suz/Sales
- Created a new database "Sales_US" using sql mgmt studio
- Created a managed path "SalesUS" with explicit
- Ran stsadm -o addcontentdb but it gives following error http://intra.df.suz/SalesUS
The attach operation cannot continue because another object in this farm already contains the same ID. Each object in a farm must have a unique ID. In order to proceed with the attach operation you mu st assign a new ID to this database. To attach this database with a new ID, use the Mount-SPContentDatabase command with the -AssignNewDatabaseId parameter. Note that if this new database and an exist ing database contain the same site collections, attaching this database will likely result in orphaned site collections due to conflicts between the two databases.