Attach a database without the corrupted log file

[ralpheberl]

Hello
Im asking if it possible that a attach a .MDF datafile without the .LDF
I want that because i have a corrupted Log file nd when i attach the database raise the following error:-
-----------
The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.
--------------------
I just need the data file This what i need and i dont need the corrupted Log file any more
i tried
sp_attach_single_file_db 'new_2009', 'C:\Data\new_2009_Data.MDF'
but the same error comes up.
Please note i have no recent backup so dont suggest to restore the database from backup
Thanks

[gandolf989]

You should know that this is a website devoted to Oracle databases, not SQL Server
databases. So your post is off topic. however, it seems to be possible. This should
help you to get started.

http://tinyurl.com/kqexh2v

[bobbyrobles]

Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.

After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.

Finally go ahead and execute DBCC CHECKDB like this

DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

Guide above might be not effective, in such case use software for corrupted sql data https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox