Tools to Read .ldf file in sql 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Tools to Read .ldf file in sql 2005

Author

Topic

buzzi
Starting Member

48 Posts

Posted - 2008-09-16 : 17:30:15

Hello all,
Are there any tools that anybody used to read a transaction log file in sql server 2005(.ldf). my company is willing to buy a tool,but i need to get a tool that works, please let me know if somebody used these kind of tools

Thanks a lot

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-16 : 18:15:25

Check out Lumigent's Log Explorer. Red Gate also has a tool.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Yeoh Ray Mond
Starting Member

49 Posts

Posted - 2008-09-17 : 11:23:40

Red Gate's tool is Log Rescue, and is free, but only works for SQL Server 2000 transaction logs. You can download it here.

Aside from Lumigent, ApexSQL also offers a log reader. You can read more about it here.

Ray Mond
SQLBackupRestore.com - your quick guide to SQL Server backup and recovery issues
SQL Inspect - SQL Server query analysis made simple
SQL Image Viewer - retrieve, view, convert and export images directly from SQL Server, SQLite and Firebird databases.

buzzi
Starting Member

48 Posts

Posted - 2008-09-17 : 11:36:22

Tara & Ray!, thanks for the reply,
Does transaction log records every thing,we are having deadlock issuses in production yesterday, and i tried to reproduce the blocking in production using our application, and was not successful, because each time i use the application, it was working fine,So i was trying to find out whether when ever sql server suffers from blocking does it record anything in the Transaction log(.ldf), if it does then this log tool will be very helpful to me

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-17 : 11:55:07

Deadlocking and blocking are two different thing.You can Blocking info with master..sysprocesses .One way to log Deadlock info is to Enable trace flags (-T 1205 or -T 1222(SQL 2005) and -T 3605( to log in Error log).

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-17 : 13:16:36

If you are experiencing deadlocks, then the way to resolve this is not via a log reader. How to resolve it is discussed in detail in SQL Server Books Online and other online resources.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

joyal.jhaveri
Starting Member

1 Post

Posted - 2008-10-01 : 07:21:28

The redgate and Lumigent have tools but it is only for sql server 2000. what to do for sql server 2005?

Thanks.

Regards,
Joyal

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2008-10-01 : 11:26:56

select * from fn_dblog(null,null)- This gives you log info

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-01 : 13:01:17