Restoring a site in the same farm but different managed path

Question

I need to restore a site "Sales" within same web application. Here is what I did?

1. Created a backup of "Sales_DB" using sql management studio. http://intra.df.suz/Sales
2. Created a new database "Sales_US" using sql mgmt studio
3. Created a managed path "SalesUS" with explicit
4. 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.

Answer 1

When you take a backup of the site it will keep the GUID. This GUID should be unique, then only the application will work as expected.

Hence what you are trying to achieve will not work.

You can probably try using

• Export-SPWeb

• Import-SPWeb

Also take a look at this Restore a copy of the same site collection insdie the same web application for detailed answer.

Answer 2

Try this:

Create an new Site collection with the URL/Path that you want ['http://intra.df.suz/SalesUS'] (...assuming it is created with a ContentDB named [SalesDB_To_Delete.mdb])

Using powershell: Mount-SPContentDatabase -Name 'Sales_US' -WebApplication 'http://intra.df.suz/SalesUS'

Next:
Get-SPContentDatabase -Identity 'SalesDB_To_Delete' | Dismount-SPContentDatabase

Do iisreset and browse to the site. Once it works, you may delete [SalesDB_To_Delete] from SSMS

That worked for me.

Good luck.