What is a TUF file in SQL server | .tuf file in Log shipping | SQL Interview questions | Ms SQL

Опубликовано: 06 Август 2022
на канале: Right to Learn @BK
8,381
158

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...  


Смотрите видео What is a TUF file in SQL server | .tuf file in Log shipping | SQL Interview questions | Ms SQL онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Right to Learn @BK 06 Август 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,381 раз и оно понравилось 158 людям.