How to see tranasaction log data

Question

How to see tranasaction log data

su_kumar11

SSCommitted

Points: 1675
More actions
June 5, 2008 at 2:28 am

#129387

Hi,
I would like see the data of transaction data in sql server.
So How could i see those data? Please tell me as soos as possible.
Regards,
Sunil

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ola Hallengren Hall of Fame Points: 3970 More actions · Answer 1

You need a third party log reader tool to read the transaction log. I know of Lumigent Log Explorer, Red-Gate SQL Log Rescue and LiteSpeed Log Reader.

Ola Hallengren

http://ola.hallengren.com

su_kumar11 SSCommitted Points: 1675 More actions · Answer 2

Hi,

Now could u tell me that how can i see rollback data through

SQL Log Rescue?

Regards,

Sunil

Ola Hallengren Hall of Fame Points: 3970 More actions · Answer 3

I haven't used SQL Log Rescue. I checked the documentation and it seems like it only supports SQL Server 2000. So maybe this was not a great advice. Have a look at the other products.

Ola Hallengren

http://ola.hallengren.com

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 4

Michael Earl-395764

SSC Guru

Points: 53873

June 5, 2008 at 5:16 am

#824708

DBCC LOG(-DATABASE NAME-,-DETAIL -1,1,2,3,4-)