Adityaraj wrote:
Asrujit SenGupta, Why can ArcGIS connect to a database created (backup and restore) on a same instance with different name? What is the technical limitation here exactly?
I am confused. Are you asking why CAN ArcGIS connect or why it CAN'T?
Cause
The cause of such an error may be linked to restoring a database in SQL Server Enterprise Manager/Management Studio under a different name than the original backup or datafile.
Unfortunately, it is not possible to rename an ArcSDE geodatabase once it has been created. The name of the original database is hard-coded in database objects. When the name of a database has been changed using a stored procedure or a database is restored to a name different from the original, the database cannot be be accessed via ArcSDE or ArcGIS clients.