HOW TO READ .LDF FILES
-
viernes, 24 de febrero de 2012 9:52
Todas las respuestas
-
viernes, 24 de febrero de 2012 10:39 There 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.
- Propuesto como respuesta Sean GallardyMicrosoft Community Contributor, Editor viernes, 24 de febrero de 2012 15:08
- Marcado como respuesta Ed Price - MSFTMicrosoft Employee, Owner domingo, 30 de diciembre de 2012 9:14
-
martes, 29 de enero de 2013 9:30
Hi,
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.
