從 Transaction Log 讀出被刪除的紀錄

感謝 John(林英豪)提供了一篇非常有用的 blog

SQL Server – How to find Who Deleted What records at What Time http://raresql.com/2012/10/24/sql-server-how-to-find-who-deleted-what-records-at-what-time/

其中所使用的 fn_dblog 函數可以參照以下的 blog

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

http://www.sqlservercentral.com/blogs/livingforsqlserver/2012/11/19/time-pass-with-transaction-log-part-3-fn-dblog

/

One Comment

  1. Posted 2013 年 07 月 24 日 at 03:20:17 | Permalink | 回覆

    這個很有用, 謝謝分享!

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: