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,

    This was the errorlog :

    2012-11-13 16:52:48.20 spid10 Starting up database 'CMU'.

    2012-11-13 16:52:48.24 spid11 Starting up database 'ESIDATADUMP'.

    2012-11-13 16:52:48.24 spid11 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device E:\SQLDATA\sqldatafiles\ESIDATADUMP_Data.MDF.

    2012-11-13 16:52:48.23 spid9 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device E:\DNCDatafiles\DNC.mdf.

    2012-11-13 16:52:48.26 spid9 FCB::Open failed: Could not open device E:\DNCDatafiles\DNC.mdf for virtual device number (VDN) 1.

    2012-11-13 16:52:48.26 spid12 Starting up database 'DBA'.

    2012-11-13 16:52:48.26 spid12 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device E:\SQLDATA\sqldatafiles\DBA_Data.mdf.

    2012-11-13 16:52:48.26 spid12 FCB::Open failed: Could not open device E:\SQLDATA\sqldatafiles\DBA_Data.mdf for virtual device number (VDN) 1.

    2012-11-13 16:52:48.26 spid13 Starting up database 'DNC_Table_BKUP'.

    2012-11-13 16:52:48.26 spid14 Starting up database 'CanadaBT'.

    2012-11-13 16:52:48.26 spid14 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device E:\SQLDATA\sqldatafiles\CanadaBT_Data.MDF.

    2012-11-13 16:52:48.26 spid14 FCB::Open failed: Could not open device E:\SQLDATA\sqldatafiles\CanadaBT_Data.MDF for virtual device number (VDN) 1.

    2012-11-13 16:52:48.26 spid11 FCB::Open failed: Could not open device E:\SQLDATA\sqldatafiles\ESIDATADUMP_Data.MDF for virtual device number (VDN) 1.

    2012-11-13 16:52:48.26 spid15 Starting up database 'distribution'.

    Please check...

    Regards,

    Varalakshmi