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.

Advertisements

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

  1. subbarao

    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

    Reply
      1. Ambesh

        .TUF is used by sql server agent to restore the database in readonly/standby mode or simply in logshipping.

    1. Alisha

      .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

      Reply
    1. Ambesh

      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.

      Reply
  2. mdh

    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.

    Reply

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