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|||Hello,
Have you tried the command sp_attach_single_file_db ?
This will attach you datafile, but not your log file as it
seems the log file is currupt, so you may have some data
loss.
J
>--Original Message--
>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 sp_attach_single_file_db, but as you say I will get some data loss with this method
My problem is the log file never seems to been backuped, so I guess I will get quite a lot of data loss
Thanks
Siri|||That really depends upon how you have programmed your
application. Depending upon the last commit statement or
chekpoint you may of lost a lot less data than you think.
I strongly doubt if it will weeks, days or hours of lost
information, personally I think it will be minutes.
Try attaching anyway then seeing if there any timestap
fields in you app, when the last one was. That should give
you an indication.
J
>--Original Message--
>Yes,
>I have tried sp_attach_single_file_db, but as you say I
will get some data loss with this method.
>My problem is the log file never seems to been backuped,
so I guess I will get quite a lot of data loss.
>Thanks,
>Siri
>.
>