This discussion is archived
3 Replies Latest reply: Jul 2, 2012 8:33 AM by 945705 RSS

Recovering data when log files corrupt

945705 Newbie
Currently Being Moderated
I am interested to understand if you can easily salvage the data files if the log files corrupt for some reason. Thus far I cannot see how this can be easilly achieved as db_backup requires a working environment, and since the log files may have vanished, the LSN of the data files will be greater than of the last log - and therefore refuse to create the environment.

Ideally I guess, I am looking for a tool that can reset the LSN in place. It would be better to have access to your 100's of GB of data and accept a small amount of inconsistency or data loss than have nothing.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points