You are here: Re: Problem with uncommited transactions in log-file « MsSQL Server « IT news, forums, messages
Re: Problem with uncommited transactions in log-file

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация