SEO

#1 (**permalink**) 02-29-2008, 03:17 AM

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!

#2 (**permalink**) 02-29-2008, 03:17 AM

"Esteban" <ecastillo@gmail.com> wrote in message
news:8f83567b.0406180752.1b24d5ff@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

#3 (**permalink**) 02-29-2008, 03:17 AM

"Simon Hayes" <sql@hayes.ch> wrote in message news:<40d3fef1_2@news.bluewin.ch>...
> "Esteban" <ecastillo@gmail.com> wrote in message
> news:8f83567b.0406180752.1b24d5ff@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.

#4 (**permalink**) 02-29-2008, 03:17 AM

Esteban (ecastillo@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, esquel@sommarskog.se

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Analyze LDF files MS SQL Server 2000