September 23, 2002 at 6:50 am
A DATABASE SERVER WENT DOWN, WHICH I TRIED TO RECOVER USING sp_attach_db, WHEN I GOT THIS ERROR. DOES IT MEAN MY DATA IS CORRUPTED? IS THIS A VIRUS PROBLEM? IS MY DATA LOST FOREVER OR IS THERE SOME WAY TO RECOVER IT ?
=============================================================
EXEC sp_attach_db @dbname = N'NEBackOfficeOLD',
@filename1 = N'E:\NEBODATABASE\NeBackOffice_Data.MDF',
@filename2 = N'E:\NEBODATABASE\NeBackOffice_Log.LDF'
-------------------------------------------------------------
Server: Msg 3624, Level 20, State 1, Line 1
Location: filemgr.cpp:977
Expression: fcb->GetSize () < fileSize
SPID: 9
Process ID: 127
Connection Broken
AmitKGoyal
September 23, 2002 at 7:28 am
Try using sp_attach_single_file_db (move the log file to a different folder first). If that fails you might try MS Support to see if they can help. Beyond that, yes, your data might be gone and no, its probably not a virus.
Andy
September 23, 2002 at 8:07 am
thanks
but again the same underlying error.
========================================================================
--------------------------------------------
Server: Msg 945, Level 14, State 2, Line 1
Database 'NEBackOffice' cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'NEBackOffice'. CREATE DATABASE is aborted.
AmitKGoyal
AmitKGoyal
September 23, 2002 at 8:08 am
thanks
but again the same underlying error : WHAT DO I DO NOW ?
========================================================================
--------------------------------------------
Server: Msg 945, Level 14, State 2, Line 1
Database 'NEBackOffice' cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'NEBackOffice'. CREATE DATABASE is aborted.
AmitKGoyal
AmitKGoyal
September 23, 2002 at 10:09 am
Can you copy the files? If so, copy them to a new location and attach only the MDF. Let it create a new LDF.
Steve Jones
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply