🔒 Closed Sql database in status suspect

[michaelmorrison17]

I had a database in status SUSPECT (No items). I have not Backup. I've only .mdf and .ldf files.
After reading all answer regarding thi topic, I executed all commands to fix this status, but without success.
I also executed the following comands for recovering my database :

sp_detach_db 'Mydb' (and the following message: "Successfully detached database 'Mydb'." ) then executed
sp_attach_db @dbname = N'Mydb',
@filename1 = N'E:\MSSQL7\Data\Mydb_Data.MDF',
@filename2 = N'E:\MSSQL7\Data\Mydb_Log.LDF' and the following error message : ("Server: Msg 823, Level 24, State 1, Line 1 I/O error 38(Reached end of file.) detected during read of BUF pointer = 0x11c01980, page ptr = 0x1f6bc000, pageid = (0x1:0x7bea01), dbid = 7, status = 0x801, file = E:\MSSQL7\Data\Mydb_Data.MDF.
Connection Broken "

I executed command with the Service Manager stopped (I don't know if it's important)
Please I'm desperate. What can I do to recover my db.
I'm not expert in SQL Server and it would be appreciate if the answers were very clear

 

[Impostor Syndrome]

You have to address this problem at You do not have permission to view the full content of this post. Log in or register now.. There are plenty of elite programmers that can help you regarding this problem. Please read there guidelines on how to publish questions in their site.

 

[michaelmorrison17]

I'll try to follow your instructions. thank you!)

 

[johannsen]

If your database is marked suspect and you are desperate, then I'll advice you to set the status to that database, like:

update master.dbo.sysdatabases
set status = 20
where name = 'YourDatabaseName'

Very sorry that you have no backup. So if that doesn't help, then the only thing I can advise is to try to use SQL Server Recovery Toolbox that can help to do recovery for sql server. You do not have permission to view the full content of this post. Log in or register now.

 

[michaelmorrison17]

Thank you guys for your feedback and help. Thank you!