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

From: Julie (anonymous_at_discussions.microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 03:31:20 -0700

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

Relevant Pages

  • Re: WSUS 2.0 grew to 16 GB - need to fix
    ... It seems that the log file is growing (.ldf file) and that means that something could have changed the recovery model of the database. ...
    (microsoft.public.windows.server.sbs)
  • Re: Damaged log file
    ... error saying that phisycal name of .ldf file is not correct. ... How can I attach only the database without the .ldf file? ... Arnie Rowland* ... to verify that you want to create a new log file, ...
    (microsoft.public.sqlserver.setup)
  • Re: Help, I cannot attach my database again
    ... but unfortunately I do not have the old log file. ... but after I restarted the server it is gone. ... > First Attach the database with the old LDF file. ...
    (microsoft.public.sqlserver.server)
  • Re: How to attach db with missing log file?
    ... Start SQL Service ... Database fake will appear as suspect in EM ... I support PASS - the definitive, ... > allowing me to get past the missing log file, ...
    (microsoft.public.sqlserver.server)
  • RE: Shrink File?
    ... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
    (microsoft.public.sqlserver.setup)
Loading