What is .TUF file in Log Shipping?

Click to subscribe to this blog

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 175 other followers
Blog Readers
- 609,619 Readers
Grab this badge here!
Disclaimer

This is a personal blog. The opinions expressed here represent my own thoughts and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have written my personal experience on this blog. Please don't direct implement or execute any query on production before have detailed study.
Database Support
- Notes (367)
  - Database (73)
  - DB Articles (34)
  - IIS (1)
  - Microsoft Technologies (1)
  - MySQL (11)
  - Networking (7)
  - Oracle (4)
  - OS and SQL (17)
  - PostGreSQL (2)
  - SQL Scripts (36)
  - SQL Server (270)
  - SQL Server 2008 (142)
  - SQL Server 2008 R2 (136)
  - SQL Server 2011 (Denali) (46)
  - Windows OS (4)
Top Rated
Follow Me

NetworkedBlogs
Blog:
SQLDBPOOL.COM
Topics:
Sql Server, Dba, Developer

Follow my blog

About Me

Jugal Shah is the author of this blog. He has eight plus years of experience as Database Administrator and Developer in the Microsoft SQL Server and MySQL.
Contact Me

Email
jugal.shah@sqldbpool.com
Chat
jshah.sqldbpool@gmail.com
Twitter
- Steps to install the PostgreSQL on windows wp.me/pdaJF-tN 2 days ago
- What is PostgreSQL? wp.me/pdaJF-tB 2 days ago
- Steps to change logged in account password on Remote Desktop Session Windows Server 2008/R2 box wp.me/pdaJF-ty 1 week ago
Follow @imjugal
SQLDBPool Facebook Page

What is .TUF file in Log Shipping?

Posted by Jugal Shah on April 4, 2011

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.

This entry was posted on April 4, 2011 at 4:55 pm and is filed under SQL Server. Tagged: .TUF, Transaction Undo file. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “What is .TUF file in Log Shipping?”

subbarao said

April 4, 2011 at 5:24 pm
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
- Jugal Shah said
  
  April 5, 2011 at 5:57 am
  .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.
  
  Reply
- Alisha said
  
  January 11, 2012 at 8:38 am
  .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
Harithasri Sriram said

April 21, 2012 at 9:32 pm
What if this tuf get deleted accidentally? doest it affect logshipping behaviour.Pls explain.

Reply