Home Forums SQL Server 7,2000 Administration Database was in Emergency mode, single user mode - Need to bring database online RE: Database was in Emergency mode, single user mode - Need to bring database online

  • 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,