I’m 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 don’t need the corrupted Log file any more
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 don’t suggest to restore the database from backup