Thank you for the suggestion. My hard situation came up because I was told not to reconcile due to editions we are working on and was having problems with old domains in some tables so did a DB restore and backup on the server side but since we are working on a single instance could not use the same name for the "clone" DB and then have faced the problem of not able to connect ArcGIS to that DB. We have cleaning tables and domains I was able to export as XML.
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?
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.