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
> >
> >
>

Help! How can I attach a DB with Corrupted Log Files

I have a backup of a Database files that its log files are damaged ( so I
can't attach it to SQL Server) please tell me if there is a way to attach a
database when its log files are corrupted? ( this DB has two ndf files so I
couldn't use the sp_attach_single_db_file)Look at
Syntax
sp_attach_single_file_db [ @.dbname = ] 'dbname'
, [ @.physname = ] 'physical_name'
in BOL
"Par" <beatles1692@.yahoo.com> wrote in message
news:#$q3$tcdDHA.656@.tk2msftngp13.phx.gbl...
> I have a backup of a Database files that its log files are damaged ( so I
> can't attach it to SQL Server) please tell me if there is a way to attach
a
> database when its log files are corrupted? ( this DB has two ndf files so
I
> couldn't use the sp_attach_single_db_file)
>|||You might try to
1. save off the good mdf and ndf files.
2. recreate the database with the same structure.
3. detach the new empty db,
and try using THAT log to re-attach the originals...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Par" <beatles1692@.yahoo.com> wrote in message
news:%23$q3$tcdDHA.656@.tk2msftngp13.phx.gbl...
> I have a backup of a Database files that its log files are damaged ( so I
> can't attach it to SQL Server) please tell me if there is a way to attach
a
> database when its log files are corrupted? ( this DB has two ndf files so
I
> couldn't use the sp_attach_single_db_file)
>|||This may be of interest:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
--
Andrew J. Kelly
SQL Server MVP
"Par" <beatles1692@.yahoo.com> wrote in message
news:%23$q3$tcdDHA.656@.tk2msftngp13.phx.gbl...
> I have a backup of a Database files that its log files are damaged ( so I
> can't attach it to SQL Server) please tell me if there is a way to attach
a
> database when its log files are corrupted? ( this DB has two ndf files so
I
> couldn't use the sp_attach_single_db_file)
>