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.
2 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.
.TUF is used by sql server agent to restore the database in readonly/standby mode or simply in logshipping.
.trn= extension of transaction log file….
.tuf= transaction undo file ,this is generated when logshipping is configured in standby mode… this keep a record of modifications done with incompleted transactions while the backup is performed
What if this tuf get deleted accidentally? doest it affect logshipping behaviour.Pls explain.
yes it disturb logshipping u have configure logshipping again
yes if u will deleted the .tuf file ur log shipping restoration job will not work.
and your database can’t be restored . in such case you have do a full back up and subsequent log/diff. back up to get it restored.
Is there any way to change the location of .tuf file in log shipping?
I am using sql server 2005 and by default it creates it in the .trn folder,but it just has read permission to this folder,so it cant create utf file and log shipping failed.
Thanks for the comment, will get back to you soon… Jugal Shah