Knowledge Base - Technical Articles
FAQ: Can I restore an ArcSDE geodatabase with a different database name in SQL Server?
| Article ID: | 36549 |
|---|---|
| Software: | ArcSDE 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 |
| Platforms: | Windows XP, 2003Server, 2008Server |
Question
Can I restore an ArcSDE geodatabase with a different database name in SQL Server?
Answer
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.
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.
Related Information
- An error was encountered while running ArcSDE Post Installation Operation Failed, Unable to start iomgr. DBMS error code: 2714
When starting the service using the post installer, the following error message appears after the service has been created and an attempt to start the service has been made: "An error was encountered while running ArcSDE Post Installation Opera... - Re-synch SQL Server logins or users after restoring a database from backup
Instructions provided describe how to re-synch SQL Server logins or users after restoring a database from backup. When a database is restored from a backup or attached from a previously detached database, the SDE user is not in synch with the logi...
Created: 4/9/2009
Last Modified: 5/3/2011
