MS SQL Server Tools - how do I view a database transaction log?

Author

how do I view a database transaction log?

public heath vb developer

2006-03-19, 11:09 am

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

Andrew J. Kelly

2006-03-19, 11:09 am

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

--
Andrew J. Kelly SQL MVP

"public heath vb developer"
< publicheathvbdevelop
er@discussions.microsoft.com> wrote in message
news:41690AC1-B58E-436E-B728- 94A5A177FDF7@microso
ft.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

_Stephen

2006-03-22, 11:30 am

"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.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

Andrew J. Kelly

2006-03-22, 8:33 pm

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

"_Stephen" < srussell@electracash
.com> wrote in message
news:%23TYg6%23cTGHA
.5172@TK2MSFTNGP12.phx.gbl...
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:ObGBWQtSGHA.4920@tk2msftngp13.phx.gbl...
>
> 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
>

Sponsored Links