you can rebuild the databse using sp_attach_db and Sp_detach_db .

1. use sp_detach_db to detach the db.
reisntall sql 7.0
create the database with same name.
then detach it.

then use sp_attch_db to attach the old mdf and ldf file to this.

You will get the syntax and details in Books online

regards
manoj






-----Original Message-----
From: Rida Rose [mailto:[Email Address Removed] Thursday, July 24, 2003 10:40 PM
To: LazyDBA.com Discussion
Subject: My SQL Server is corrupt


Hello
I am in a serious problem. My Sql Server has gone corrupt so I had to
reinstall it. The problem is that I dont have the backup with me and very
important data was in the database. My data file and log file were on the
other partition so database.data and database.log are intact but I dont know

how to connect this information to the sql server. Please help me if any
one can. I am waiting desperately.

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page