how do I view a database transaction log?

18 Mar 2006 9:09 PM

public heath vb developer

One of our developers had all of the data from all of the tables in his
database show 0 rows. The tables were still present.

I wonder if viewing the transaction log would give a clue about the cause,
but I can't find any method for reading the transaction log to see what
operations he performed. DBCC log does not seem to show the user
transactions. I want to see the before and after data, and the operation
such as Insert, Delete, etc.

Is there such a tool?

--
Jim Durbin
Durbin Enterprises
VB developer

18 Mar 2006 9:36 PM

Andrew J. Kelly

http://www.aspfaq.com/show.asp?id=2449

--
Andrew J. Kelly SQL MVP

"public heath vb developer"
<publicheathvbdevelo***@discussions.microsoft.com> wrote in message

Show quote

news:41690AC1-B58E-436E-B728-94A5A177FDF7@microsoft.com...
> One of our developers had all of the data from all of the tables in his
> database show 0 rows. The tables were still present.
>
> I wonder if viewing the transaction log would give a clue about the cause,
> but I can't find any method for reading the transaction log to see what
> operations he performed. DBCC log does not seem to show the user
> transactions. I want to see the before and after data, and the operation
> such as Insert, Delete, etc.
>
> Is there such a tool?
>
> --
> Jim Durbin
> Durbin Enterprises
> VB developer

22 Mar 2006 4:46 PM

_Stephen

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:ObGBWQtSGHA.4920@tk2msftngp13.phx.gbl...
> http://www.aspfaq.com/show.asp?id=2449
>

I heard from a friend that the overhead on that Lumigent was to great and
they uninstalled it. They did a large volume of batch processing where
50,000 + transactions a day were getting processed in the morning. their
system was brought to it's knees and they had to remove Lumigent.

Are there other products that don't overwhelm the server?

__Stephen

23 Mar 2006 2:10 AM

Andrew J. Kelly

50K transactions is trivial. I have seen systems do that in a few seconds
rather than per day that used Lumigent. Lumigent also allows you to view
log backups which should have no performance impact on the live server just
to view the logs. But that link shows several other products as well.

--
Andrew J. Kelly SQL MVP

Show quote

"_Stephen" <sruss***@electracash.com> wrote in message
news:%23TYg6%23cTGHA.5172@TK2MSFTNGP12.phx.gbl...
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:ObGBWQtSGHA.4920@tk2msftngp13.phx.gbl...
>> http://www.aspfaq.com/show.asp?id=2449
>>
>
> I heard from a friend that the overhead on that Lumigent was to great and
> they uninstalled it. They did a large volume of batch processing where
> 50,000 + transactions a day were getting processed in the morning. their
> system was brought to it's knees and they had to remove Lumigent.
>
> Are there other products that don't overwhelm the server?
>
> __Stephen
>