Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

.tuf file Expand / Collapse
Author
Message
Posted Thursday, June 8, 2006 12:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 4, 2013 11:06 AM
Points: 397, Visits: 548
what is .tuf file created during log shipping?
Post #286072
Posted Friday, June 9, 2006 11:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 9:05 AM
Points: 331, Visits: 549
From what I can tell, it is the pointer (or information file) that tells log shipping where it left off with its last restore.  We log ship throughout the day, but only restore the log backups on the secondary database between 2 & 4 a.m.  There is always a .tuf file after the last restore.  I imagine that it contains the FirstLsn and LastLsn of the T-Log backups, but that's just a guess.


Post #286363
Posted Friday, June 9, 2006 11:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 4, 2013 11:06 AM
Points: 397, Visits: 548
thanks. I am unable to find anything on microsoft site about this. Anyone else wanna take a shot at this?
Post #286366
Posted Friday, June 9, 2006 12:52 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 20, 2014 4:19 PM
Points: 388, Visits: 231
Sure, though it's not my info, but from a message posted by an msce:

http://www.mcse.ms/archive81-2005-5-1633597.html

The .tuf file is the Transaction Undo File, and is created when performing log shipping to a server in Standby mode. From our friend, the msce:

In the standby mode, database recovery is done when the log is
restored and this mode also creates a file with the extension .TUF
(which is the transaction Undo file on the destination server). In
this mode we will be able to access the databases.



Post #286392
Posted Friday, June 9, 2006 1:20 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 4, 2013 11:06 AM
Points: 397, Visits: 548

Thanks Brendt. Here is what I found

Transaction undo file

File containing information regarding any modifications that were made as part of incomplete transactions at the time the backup was performed. A transaction undo file is required if a database is loaded in read-only state. In this state, further transaction log backups may be applied.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Post #286404
Posted Friday, September 4, 2009 8:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 5, 2012 7:22 AM
Points: 19, Visits: 170
I need small information regarding .tuf file..Where .tuf file is created in sql server ?
Post #782959
Posted Tuesday, February 23, 2010 10:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 12:09 AM
Points: 60, Visits: 561
This file will be located in the same folder(on the secondary/standby server) from where Log shipping is picking the transacation log(*.trn) files for restore.
Post #871686
Posted Wednesday, November 3, 2010 9:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 21, 2011 11:20 AM
Points: 17, Visits: 96
Hi All,

Any Idea how to bring the database to RECOVERY mode when .tuf file is missing?

I am also not sure how it's getting deleted everytime.

Thanks!!
Jeet
Post #1015666
Posted Thursday, November 4, 2010 6:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
To bring the database online use following syntax (this also works when .tuf file is missing):
RESTORE <database> WITH RECOVERY

Post #1015811
Posted Friday, June 24, 2011 12:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 7:52 AM
Points: 49, Visits: 147
how can i restore when TUF file is missing..please help me out
Post #1130937
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse