Analyze LDF files MS SQL Server 2000

[Esteban]

Anybody nows a tool to analyze LDF files in MS SQL Server 2000?
I mean, a tool that converts a LDF file in a set of SQL transactions?
(similar to dbtran in sybase)

thanks!

[Simon Hayes]

"Esteban" <ec*******@gmail.com> wrote in message
news:8f**************************@posting.google.c om...

Anybody nows a tool to analyze LDF files in MS SQL Server 2000?
I mean, a tool that converts a LDF file in a set of SQL transactions?
(similar to dbtran in sybase)

thanks!

There is nothing in MSSQL itself (except for some undocumented commands),
but there are third-party tools available, such as this one:

http://www.lumigent.com/

If you are trying to achieve something specific, you might want to post more
details of your goal, and someone may be able to suggest something.

Simon

[Esteban]

"Simon Hayes" <sq*@hayes.ch> wrote in message news:<40********@news.bluewin.ch>...

"Esteban" <ec*******@gmail.com> wrote in message
news:8f**************************@posting.google.c om...

Anybody nows a tool to analyze LDF files in MS SQL Server 2000?
I mean, a tool that converts a LDF file in a set of SQL transactions?
(similar to dbtran in sybase)

thanks!

There is nothing in MSSQL itself (except for some undocumented commands),
but there are third-party tools available, such as this one:

http://www.lumigent.com/

If you are trying to achieve something specific, you might want to post more
details of your goal, and someone may be able to suggest something.

Simon

Thanks Simon, I was trying this product, but I can't find an option
that shows me a list of SQL transactions made in the database ...
maybe I don't know how to use it.
For example, I want to know if a certain register was deleted from the
database.

thanks.

[Erland Sommarskog]

Esteban (ec*******@gmail.com) writes:

Thanks Simon, I was trying this product, but I can't find an option
that shows me a list of SQL transactions made in the database ...
maybe I don't know how to use it.
For example, I want to know if a certain register was deleted from the
database.

In the version I have, there is a "View DDL commands" under Browse, and it
seems to have the information of the kind you are looking for. There is
also a filter function.

Note that for Log Explorer to be really useful, you need to have the
database in FULL or BULK_LOGGED recovery mode.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp