FAQ: Can I restore an ArcSDE geodatabase with a different database name in SQL Server?
Can I restore an ArcSDE geodatabase with a different database name in SQL Server?
It is not possible to restore a backup created in SQL Server using a different database name than the one given to the database when the repository was initially populated.
To restore the backup of a currently existing database in order to access dated information without taking the existing database with the same name offline, follow the steps below:
1. Install a new instance of SQL Server on another machine.
2. Restore the database using the original name.
3. Synchronize the logins.
- An error is received when trying to access a SQL Server ArcSDE geodatabase that has been restored with a new name
- Re-synch SQL Server logins or users after restoring a database from backup