TUF file is a Microsoft SQL Server Transaction Undo file. .TUF File contains the information regarding any modifications that were made as part of incomplete transactions at the time the backup was performed.
A transaction undo(.TUF) file is required if a database is loaded in read-only state. In this state, further transaction log backups may be applied.
1 If so what is the main difference b/w .trn file and .tuf file.
ReplyDelete2 when to use .trn file and .tuf file
3 how to use these two these two
.Trn is log backup file and .TUF is undo file. We can not use .TUF file but we can use .TRN file using Restore Log command.
ReplyDelete