HOW TO READ .LDF FILES

所有回覆

• 2012年2月24日 上午 10:39

   

   
  

  1
  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.

  ---

  Tibor Karaszi, SQL Server MVP | web | blog

  • 已提議為解答 Sean GallardyMicrosoft Community Contributor, Editor 2012年2月24日 下午 03:08
  • 已標示為解答 Ed Price - MSFTMicrosoft Employee, Owner 2012年12月30日 上午 09:14
  •  
  • 回覆
  • 引述

   
• 2013年1月29日 上午 09:30

   

   
  

  0

  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.

  • 回覆
  • 引述