I have a spatial database on a SQL Server Instance. I want to create a copy of it in the same instance. I tried the following approaches:
- Backing up the existing XYZ DB and restoring it with a new name XYZ_Clone. Following that, I was able to connect to the XYZ_Clone via SSMS but when I attempted to set up a DB connection to it via ArcMap, I got the following error.
- Following the error, we found a root cause stating "have you recently restored your SDE database into another database. If that's the case then there is a conflict between the configuration of SDE generated schema, as it will hold the name of the previous database but your current new database name is Changed.". So, we edited the number of entries storing the DB name such as
That didn't help. So, I deleted the XYZ_Clone and created a new Enterprise Geodatabase through ArcMap 10.3 using the 'Create Enterprise Geodatabase' tool.
Then I tried to copy the XYZ DB to XYZ_Clone DB using the instructions given in the following link. Copying a geodatabase
After this, I am getting the error messages that features were not copied as the [Shape] columns were not found.
Is there a straightforward way/process of creating a Spatial DB clone?