Friday, February 24, 2012 9:52 AM
Friday, February 24, 2012 10:39 AMThere is no supported way to do this. There is an undocumented command, fn_dump_dblog() (mentioned in here: http://www.karaszi.com/SQLServer/info_minimizing_data_loss.asp). Use as own risk. There are also 3:Rd party products (I believe) for this.
- Proposed As Answer by Sean GallardyMicrosoft Community Contributor, Editor Friday, February 24, 2012 3:08 PM
- Marked As Answer by Ed Price - MSFTMicrosoft Employee, Owner Sunday, December 30, 2012 9:14 AM
Tuesday, January 29, 2013 9:30 AM
It is possible with the following DBCC command.
DBCC LOG ('<DATABASENAME>')
It will return a table contain current LSN,Operation,Context,Transaction ID,Log Block Generation. In this one with help of Operation column you can find what operation done on LOG file. Only drawback is it will not provide full information.