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
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
In Database
Share this post:
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »