Search for questions :
My Profile
Categories

Mousumi

Open Question Bookmark and Share

Recovering Data from Corrupted Transaction Log File of MS SQL Database ?

Last night while I was working on my computer, suddenly there was an abnormal termination of the computer. When I again switched on the computer, I was shocked to find that the transaction log file of MS SQL Database has gone corrupt.

I need the contents from the log file badly as I need to make a presentation report in my office. Can anybody help me out of this mess?

352 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

LucyKhare 		When the Transaction Log File gets corrupted, it is really very difficult to extract data from the required .mdf file. For recovering the data, you need to repair the MS SQL Database by using the following command:

• SP_ATTACH_DB-SINGLE_FILE_DB

If the command is not able to help you recover the data, then go through the following steps:

• Create a back up of the mdf file
• Detach the corrupted database from the server
• Create a new database file
• Rename the newly created database file without .MDF extension
• Start the SQL services
• Open the Query Analyzer and execute SP_ CONFIGURE
• Update the database system

In this way you can recover all your data from the corrupted Transaction Log Files of MS SQL Database.


Posted 352 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0