Hi,
After restart of server also the database in emergency mode but those files we can able to see. We copied all the .mdf and .ldf files to some new location and created the required database in that new sql server by attaching these mdf and ldf files. Now we have atleast one source for current use.
It seems to be issue has been fixed.:-)
Planning to do the same thing on the emergency mode database also.
Thanks
&
Regards,