Knowledge Base - Technical Articles


Technical Article   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.

Related Information


Created: 4/9/2009
Last Modified: 5/3/2011

If you would like to post a comment, please login