|  | Posted by Holyman on 09/07/05 18:35 
Thanks - I will try this one.
 I have tried som other 3rd partie apps to view the log file.. But it
 does not show the uncommited transactions..
 
 But I know they are still in the ldf file, because when I open the
 file in a hex-editor, I can see some of the data.. But it is not very
 readable
 
 
 
 On 7 Sep 2005 08:23:46 -0700, "Simon Hayes" <sql@hayes.ch> wrote:
 
 >If you restarted the service, then the open transaction will simply
 >have been rolled back, as if it never happened. The easiest thing is
 >probably simple to redo the operations, but if that's not possible then
 >there are third-party tools which can read logs and recreate individual
 >statements. This is one (which I've never used):
 >
 >http://www.lumigent.com/products/le_sql.html
 >
 >Simon
  Navigation: [Reply to this message] |