User Database marked with suspect

[dschneider]

Hi all,
I have a big problem with a user Database on SQL-Server7.0. The Application which runs on this Database is Baan. So I handled datainput who creates many new tables. Short
before the end of this Process, the Database crashes. Now I can't get access to the Database neither with the application BaaN nor with the enterprise manager. The system is not able to rebuild the database.
So the main problem is, I have no Backup!
At the moment I have detached the Database, to install SP3. When I run the query exec sp_detach_db 'baandb' there was the error message" Errorcode 947, severity code 16, state 1, row 0".
Now I cannot atach the Database again, because of error 3624, severity code 20, state 1, row 1. Location: page.cpp:3008
expression: spaceneeded < spaceContig && spaceneeded <= space_usable.
This is exactliy the error, from the first crash.

Can anyone tell me, how to repair the database?

If there are some helpful tips, you will rescue my life!
Thanks for all help!

Daniel

 

[aalmeida]

What I would do?
1) Stop SQL Server;
2) Create security copyes of the Data and Log files ...\baandb.mdf ...\baandb.ldf;
3) Check the free space on the hd
4) Check the atributs of the Data and log files for the db, sql server must have full control over them therefore they can not be read only.
That's where I would start.