Corrupted log file

[jason]

Need to recover from a corrupted log file. The database in Enterprise
Manager shows the database as corrupt.

Using sp_Attach_db produces a corrupt log message.

Any way to recover the data?

Thanks

[Marc]

Re: Corrupted log file

Hi Jason,

Did you try to restore from a backup and adding the backup log files to it
until the point of corruption?

I'm assuming your running with a database recovery model of FULL.

Regards,
Marc,
:)

"jason" <jasonl22@yahoo .com> wrote in message
news:458a6e24.0 311131058.46777 aeb@posting.goo gle.com...[color=blue]
> Need to recover from a corrupted log file. The database in Enterprise
> Manager shows the database as corrupt.
>
> Using sp_Attach_db produces a corrupt log message.
>
> Any way to recover the data?
>
> Thanks[/color]

[John Bandettini]

Re: Corrupted log file

Jason

Have you tried sp_detach_db and then sp_attach_singl e_file_db. This
will replace your corrupt transaction log with a shiny new one.

Regards

John

"Marc" <marcj@no.spam. here.please.net lane.com> wrote in message news:<3fb3e285$ 0$222$1b62eedf@ news.euronet.nl >...[color=blue]
> Hi Jason,
>
> Did you try to restore from a backup and adding the backup log files to it
> until the point of corruption?
>
> I'm assuming your running with a database recovery model of FULL.
>
> Regards,
> Marc,
> :)
>
> "jason" <jasonl22@yahoo .com> wrote in message
> news:458a6e24.0 311131058.46777 aeb@posting.goo gle.com...[color=green]
> > Need to recover from a corrupted log file. The database in Enterprise
> > Manager shows the database as corrupt.
> >
> > Using sp_Attach_db produces a corrupt log message.
> >
> > Any way to recover the data?
> >
> > Thanks[/color][/color]