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 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.
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 message 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. If 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