How can I view SQL Server 2005 Transaction log file

Question

How can I view the SQL Server Transaction Log File (.trn)?

I'd like to be able to look inside the trn file at the individual transactions. Some records were deleted from a database and I need to know when, how and by who.

Thanks Neal

Edit: I have .bak files from before and after the deletion, and .trn files from during.

Edit (2010-11-16): Discussed at length here: http://www.sqlservercentral.com/Forums/Topic1019240-357-1.aspx

Try using [ApexSQL Log](http://www.apexsql.com/sql_tools_log.aspx) — Kenneth Hampton, May 17 '13 at 09:21

Preet Sangha · Answer 1 · 2013-12-02T20:18:54.827

3

Select * from ::fn_dblog(null,null)

Is a virtual table over the log

edited Dec 02 '13 at 20:18

answered Nov 11 '10 at 10:43

Preet Sangha

64,563
18
145
216

can you give a little more information on what you mean here Preet? I have a .trn file - so could you start from there? Thanks – Neal Hudson Nov 11 '10 at 10:48
Comments didn't exist when this was written. It's now been edited. – Preet Sangha Dec 02 '13 at 20:19

score 1 · Answer 2 · answered Sep 29 '13 at 18:43

1

Use this command :

Select * from ::fn_dblog(null,null)

And for more information see this link : How Do You Decode A Simple Entry in the Transaction Log

answered Sep 29 '13 at 18:43

Ardalan Shahgholi

11,967
21
108
144

How can I view SQL Server 2005 Transaction log file

2 Answers2