Developer creates SQL Server data recovery tool without needing prior CDC setup
A developer built a tool called LogCarver that recovers deleted SQL Server rows without requiring Change Data Capture or auditing features to be pre-enabled. The tool works by directly reading and reverse-engineering SQL Server's undocumented transaction log function, fn_dblog. During testing, the developer discovered and fixed critical bugs, including one that silently excluded data from heap tables and another that mishandled tables with extra indexes. The tool currently supports several common data types but has some known limitations, such as handling of TRUNCATE operations.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in