topic Database recreation with error 3624 in BackOffice Products

Database recreation with error 3624

Jojo Villarmino — Mon, 08 May 2006 00:49:32 GMT

My database got marked SUSPECT status. I tried to dettach it but it cannot be dettached. I made an uninstall and reinstall of my sql server 2000. When I tried to attach it, I received an error:

Server: Msg 3624, Level 20, State 1, Line 1

Location: page.cpp:2610
Expression: spaceNeeded <= spaceContig && spaceNeeded <= space_usable
SPID: 57
Process ID: 1744

Connection Broken

I read a thread from this forum on how to fix this problem. But I am still getting the error. I noticed my transaction log(LDF) could be corrupted since its just 504KB and my MDF is almost 8GB.

Re: Database recreation with error 3624

Jon Finley — Mon, 08 May 2006 19:22:24 GMT

Excerp from: http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=107731&admit=-682735245+1147133867256+28353475

To attach the Database, I stopped SQL-Server, copied the Databasefile (e.g: baandb.mdf & baandb.ldf), then I started SQL-Server again, and deleted the baandb-Database. Next I recreated it as an empty Database, with exact the same name and parameters as the old one. After that I stopped SQL-Server again, deleted the new baandb.mdf & .ldf in Windows Explorer and renamed the saved one to the new one. After that started SQL-Server again, and the Database is attached and not marked with suspect. Now you can run DBCC-Tools.

Jon

Re: Database recreation with error 3624

Jojo Villarmino — Mon, 08 May 2006 20:46:29 GMT

Thanks Jon!

I followed this method. Im still getting the same error message. If my transaction log (LDF) is corrupted, can I still make use of the data file (MDF) to recover my database?

Re: Database recreation with error 3624

Igor Karasik — Tue, 09 May 2006 00:38:48 GMT

Jojo,

To attach only MDF file execute the command:
SP_ATTACH_SINGLE_FILE_DB 'dbname','mdf file name'

But I think your problem is corrupted mdf file, and not log file.
Generally speaking LDF size have no correlation with MDF size, if you use simple recovery mode your ldf file maybe just 100 Kb for any size of MDF file.

I hope you have good backup of database.....

Re: Database recreation with error 3624

Jojo Villarmino — Tue, 09 May 2006 04:03:46 GMT

Thanks for your reply again Jon. I also tried running SP_ATTACH_SINGLE_FILE_DB, but it is looking for the log file. Thanks again