Corrupted log file

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?

ThanksHi 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.0311131058.46777aeb@.posting.google.c om...
> 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|||Jason

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

Regards

John

"Marc" <marcj@.no.spam.here.please.netlane.com> wrote in message news:<3fb3e285$0$222$1b62eedf@.news.euronet.nl>...
> 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.0311131058.46777aeb@.posting.google.c om...
> > 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