Browse by Tags

Tagged Content List
  • Blog Post: Point-in-time restore and knowing where to stop

    In some disaster recovery scenarios, a database needs to be restored to a point in time before a particular operation has occurred, e.g. before a user mistakenly dropped a table, ran a DELETE or UPDATE with no WHERE clause, etc. If the database is in the full recovery mode and the log backup chain is...
  • Blog Post: Reading database transaction log with fn_dump_dblog()

    While the format of SQL Server transaction log is not publicly documented, there is a number of ways to view the contents of the log. This is sometimes necessary for troubleshooting and forensic purposes. One way is the DBCC LOG command. Another is fn_dblog() table-valued function. Both are undocumented...
Page 1 of 1 (2 items)