Re: Damaged log file

I was suggesting that you use Explorer and Delete the log file
(dbname*.ldf) -first making a copy of the log file (or renaming it). And
then re-attach the database.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."



"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8E9390D8-ADF3-4973-B68E-36B2A1D0EFAD@xxxxxxxxxxxxxxxx
Hi,

How can I do that copy you mentioned.
Sorry but I'm not experienced in SQL Server.

Regards.

"Arnie Rowland" wrote:

If you were attaching the database, and got that message, after making a
copy, you could attach the database without a log file. You will be
prompted
to verify that you want to create a new log file, and click ok.

At that point, if your log file should be larger than the default size,
you
may wish to increase the file size.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."



"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A3BF3440-FB81-4202-903A-532A51B5B3A1@xxxxxxxxxxxxxxxx
Hi,

I made an attach of a database, but then got the error 9004: Error
while
processing the log file.
Is there any chance of putting this database to work?

Thanks in advance.





.

Relevant Pages

  • 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)
  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Transaction log problems
    ... just before you backup the ... database change the recovery model to ... Simple, shrink the log file then change it back to Full, ... >transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)
  • Re: sp_attach_single_file_db
    ... Being that Rob has access to the database and can still ... Stop sql server and rename the existing MDF to a new one and copy the ... Now execute the undocumented DBCC to create a log file ...
    (microsoft.public.sqlserver.server)