You might want to try tools from ApexSQL, Lumigent or Red-Gate (note that
the latter is free but 2000 *only*... you didn't bother to tell us which
version this is, so it may or may not be relevant / worth a shot):
http://www.apexsql.com/sql_tools_log.asp
http://www.lumigent.com/products/log_explorer.html
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
However, I am not sure whether any of them can work with a log file that is
not attach-able. I have used them to reverse transactions from online log
files but never to recover data from an offline log file that is corrupt.
(You also might now want to consider implementing some kind of disaster
recovery solution. Regular backups would be a good start. Unfortunately,
most people wait until the first time they get hosed before they consider
this an important part of planning and development.)
On 8/3/08 9:27 PM, in article
4C64A2D5-99ED-4F80-8062-F734792BC859@
microsoft.com, "John"
gmail.com> wrote: