I don't suppose that you managed to detach the database before the crash? ;)

I'm not sure if this will work or not. Create a new database with everything named the same and the files in the same location. Stop SQL Server and replace the new MDF and LDF files with the actual ones.

I've not tried this. I'm not making any promises. You might want to check some of the other SQL Server sites.

-Mike


>Hi all,
>just one bad morning my NT got crash.
>I want to recover one SQL 7 database. unfortunately i dont have the latest backup of it with me. however i've got the latest mdf and ldf files.
>can anybody please tell me how to recover the database through mdf and ldf files.
>
>
>TIA