What is .TUF file in Log Shipping?


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.

About these ads

8 thoughts on “What is .TUF file in Log Shipping?

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

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

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

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s