HELP ! Database recovery problem

Question

HELP ! Database recovery problem

amitkgoyal

Newbie

Points: 3
More actions
September 23, 2002 at 6:50 am

#158099

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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119912 More actions · Answer 1

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

http://www.sqlservercentral.com/columnists/awarren/

Andy
Connect with me on LinkedIn

amitkgoyal Newbie Points: 3 More actions · Answer 2

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 Newbie Points: 3 More actions · Answer 3

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

Steve Jones - SSC Editor SSC Guru Points: 739010 More actions · Answer 4

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

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones