How can we help you today? How can we help you today?

SQL Backup Logs and fn_dump_dblog()

We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. 

There are a few undocumented functions for reviewing the logs, 
https://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

one of which is fn_dump_dblog, which can review data in a log file. However, since the Backup Pro logs are compressed and have a .sqb extension, is there any way, other than the slow and time consuming "backup file converter" utility? 

We were able to figure it out using a SQL monitor app (sorry, not SQL Monitor) to pin-point the time and user, then restore the log to a specific time to confirm it, but it would have been nice to use these undocumented function(s) instead.
DBNewbie_2007
0

Comments

1 comment

Sort by
  • Eddie D
    Hi, thank you for your forum post.

    Sadly, to my knowledge there aren't any plans in the near future for SQL Backup to make use of fn_dump_dblog().

    I recommend that you post, comment and vote in the SQL Backup UserVoice.  The UserVoice forum is the best place to submit feature suggestions.

    Many thanks
    Eddie


    Eddie D
    0

Add comment

Please sign in to leave a comment.