Recover Deleted Data from Transaction Log Backup File using fn_dump_dblog() function

standard post
yigitaktan  -  
0 Comments  -  

A transaction log is a physical file in which SQL Server stores a record of all the transactions performed on the database with the log file is associated. SQL Server automatically creates a transaction log for every new database. The database recovery model has to be Full or Bulk-logged when you take transaction log backup. In this article, it will be demonstrated how to recover deleted data from transaction log backup files. We will use fn_dblog() function to read the transaction log for finding the deleted data that haven’t been cleared from the active part of the transaction log. After the Transaction Log will get clear, we will try to recover deleted data from a Transaction Log backup file using fn_dump_dblog(). Read More