Re: Damaged log file

Hi,

I made that, deleted the *.ldf file and re-attach the database, but I get an
error saying that phisycal name of .ldf file is not correct.
How can I attach only the database without the .ldf file?

Thanks.

"Arnie Rowland" wrote:

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: 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)
  • Recover db from .mdf and .ldf files in sql server7.0
    ... but not your log file as it ... Backup file of master database exists. ... How to get the information in the .ldf file? ...
    (microsoft.public.sqlserver.server)
  • Re: .LDF files and SharePoint Portal
    ... So when you take a backup of the database, ... I have some questions about .LDF files and Sharepoint. ... Is it safe to delete the data in the .LDF file or will it cause ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Crash Recovery
    ... You can't apply an LDF file to a restored database backup. ... >> How to restore the BAK file. ...
    (microsoft.public.sqlserver.server)
  • Re: Damaged log file
    ... I was suggesting that you use Explorer and Delete the log file ... Arnie Rowland* ... your heart must accompany your knowledge." ... you could attach the database without a log file. ...
    (microsoft.public.sqlserver.setup)