HELP! How to repair corrupted database log file?

Hello folks,
Sorry if this has been asked before -- but I wonder if there is a check tool
that will fix/repair corrupted Db log file?
I cannot attach the database since it says the log file is corrupted.
I cannot use the DBCC checkdb script since the database is not attached to
the system tables.
I don't have any backups (they are corrupted)
HHHHHEEEEEEELLLLLPPPPP!!!!
Any advice is apprechiated!
DanDan,
If you have already or can detach the database using sp_detach_db then
reattach it using
sp_attach_single_file_db which will build a new log file. (Loses the data
in the log, of course.)
Russell Fields
"Microsoft News" <dant@.cdkkt.com> wrote in message
news:e3iTSAmmDHA.2424@.TK2MSFTNGP10.phx.gbl...
> Hello folks,
> Sorry if this has been asked before -- but I wonder if there is a check
tool
> that will fix/repair corrupted Db log file?
> I cannot attach the database since it says the log file is corrupted.
> I cannot use the DBCC checkdb script since the database is not attached to
> the system tables.
> I don't have any backups (they are corrupted)
> HHHHHEEEEEEELLLLLPPPPP!!!!
> Any advice is apprechiated!
> Dan
>|||did you try sp_attach_single_file_db ? Using this command
you can attach a datafile without logfile, sql server will
create a blank log file for you.
>--Original Message--
>Hello folks,
>Sorry if this has been asked before -- but I wonder if
there is a check tool
>that will fix/repair corrupted Db log file?
>I cannot attach the database since it says the log file
is corrupted.
>I cannot use the DBCC checkdb script since the database
is not attached to
>the system tables.
>I don't have any backups (they are corrupted)
>HHHHHEEEEEEELLLLLPPPPP!!!!
>Any advice is apprechiated!
>Dan
>
>.
>|||Thanks for responding...
I have tried to reattach using the sp_attach_single_file_db and I got back
an error:
The LSN (9731:1931:1) passed to log scan in database 'd110202' is invalid.
What does this mean'
Dan
"Microsoft News" <dant@.cdkkt.com> wrote in message
news:e3iTSAmmDHA.2424@.TK2MSFTNGP10.phx.gbl...
> Hello folks,
> Sorry if this has been asked before -- but I wonder if there is a check
tool
> that will fix/repair corrupted Db log file?
> I cannot attach the database since it says the log file is corrupted.
> I cannot use the DBCC checkdb script since the database is not attached to
> the system tables.
> I don't have any backups (they are corrupted)
> HHHHHEEEEEEELLLLLPPPPP!!!!
> Any advice is apprechiated!
> Dan
>|||Dan,
Your database d110202 did not have multiple log files did it?
Russell
"Dan Thurman" <dant@.cdkkt.com> wrote in message
news:%23JtdpNnmDHA.988@.TK2MSFTNGP10.phx.gbl...
> Thanks for responding...
> I have tried to reattach using the sp_attach_single_file_db and I got back
> an error:
> The LSN (9731:1931:1) passed to log scan in database 'd110202' is
invalid.
> What does this mean'
> Dan
> "Microsoft News" <dant@.cdkkt.com> wrote in message
> news:e3iTSAmmDHA.2424@.TK2MSFTNGP10.phx.gbl...
> > Hello folks,
> >
> > Sorry if this has been asked before -- but I wonder if there is a check
> tool
> > that will fix/repair corrupted Db log file?
> > I cannot attach the database since it says the log file is corrupted.
> >
> > I cannot use the DBCC checkdb script since the database is not attached
to
> > the system tables.
> >
> > I don't have any backups (they are corrupted)
> >
> > HHHHHEEEEEEELLLLLPPPPP!!!!
> >
> > Any advice is apprechiated!
> >
> > Dan
> >
> >
>