0 votes
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
Saturday, May 30 2015, 03:51 PM
Share this post:
Responses (0)
  • There are no replies here yet.
Your Reply