Database recreation with error 3624

[Jojo Villarmino]

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.

[Jon Finley]

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

[Jojo Villarmino]

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?

[Igor Karasik]

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.....

[Jojo Villarmino]

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