Read the database transaction log file ie LDF file

Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
PushkarThere are various third-party tools that can help.
LogPI, Log Explorer, etc.
Recently I've been using Red Gate's tool quite a bit... I think it's a bit s
impler to use than the other available tools:
http://www.red-gate.com/sql/sql_log_rescue.htm
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Pushkar" <pushkartiwari@.gmail.com> wrote in message news:OOFQjIMqFHA.904@.TK
2MSFTNGP10.phx.gbl...
Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
Pushkar|||Use a third party tool.
http://www.aspfaq.com/2449
"Pushkar" <pushkartiwari@.gmail.com> wrote in message
news:OOFQjIMqFHA.904@.TK2MSFTNGP10.phx.gbl...
Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
Pushkar|||You can use the undocumented command DBCC LOG. See:
[url]http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp[/ur
l]
A better approach would be to use a third-party tool, such as
Lumigent Log Explorer, ApexSQL Log or Red-Gate SQL Log Rescue.
Razvan