What is a .tuf file in SQL server ??

::-This is one of the frequently asked interview question and it plays a important role in one of the database high availability and disaster recovery i.e., Log shipping.

Transaction Undo File - contains transactions/modifications that were not committed on the source database but were in progress when the transaction log was backed up AND when the log was restored to another secondary database.

When another transaction log is restored, SQL Server will fetch the transactions from undo file and check with new tlog backup whether the same is committed or not.

Please click on the below link to watch a video on Log Shipping in SQL server
   • Log Shipping in SQL server || Log Shi...  

WRK file: Click to watch
   • What is a WRK file in SQL server | .w...