HOW TO READ .LDF FILES
-
24 Februari 2012 9:52
Semua Balasan
-
24 Februari 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.- Disarankan sebagai Jawaban oleh Sean GallardyMicrosoft Community Contributor, Editor 24 Februari 2012 15:08
- Ditandai sebagai Jawaban oleh Ed Price - MSFTMicrosoft Employee, Owner 30 Desember 2012 9:14
-
29 Januari 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.