Recover db from .mdf and .ldf files in sql server7.0

Hi,
how to recover a user database in sql server 7.0 if I only have the .mdf fil
e and the .ldf file but no backup file? Backup file of master database exist
s.
Found a utiliy tool called "MSSQLRecovery" on the net that recreates the dat
abase script out of the .mdf-file, so far so good. But I need the informatio
n in the .ldf file too.. How to get the information in the .ldf file?
Thanks.Hi,
With the MDF and LDF files did you tried attaching the database?
steps:
1. Copy the MDF and LDF to harddisk say (c:\mssql\data)
2. use the below command to attach the database in to sql server
sp_attach_db 'dbname','c:\mssql\data\dbname.mdf','c:\mssql\data\dbname.ldf'
This will work out if your mdf and ldf is not corrupted.
Thanks
Hari
MCDBA
"Siri" <anonymous@.discussions.microsoft.com> wrote in message
news:996575F8-05F3-4392-A8B3-7E858AC6CF68@.microsoft.com...
> Hi,
> how to recover a user database in sql server 7.0 if I only have the .mdf
file and the .ldf file but no backup file? Backup file of master database
exists.
> Found a utiliy tool called "MSSQLRecovery" on the net that recreates the
database script out of the .mdf-file, so far so good. But I need the
information in the .ldf file too.. How to get the information in the .ldf
file?
> Thanks.|||Yes,
I have tried to attach the database using sp_attach_db, but I got the messag
e that the .ldf file is corrupt.. :o(
Is there anything else I can do to recover data from the .ldf file?
Thanks!
Siri|||You could try to attach only the mdf file, using sp_attach_single_file_db. I
f that doesn't work, I suggest
that you open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Siri" <anonymous@.discussions.microsoft.com> wrote in message
news:CFC69081-B490-42D0-AA27-DAE197B37AE9@.microsoft.com...
> Yes,
> I have tried to attach the database using sp_attach_db, but I got the message that
the .ldf file is
corrupt.. :o(
> Is there anything else I can do to recover data from the .ldf file?
> Thanks!
> Siri