.tuf file

Question

.tuf file

sqlstar2011

SSCertifiable

Points: 6000
More actions
June 8, 2006 at 12:15 pm

#62400

what is .tuf file created during log shipping?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 1

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.

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 2

thanks. I am unable to find anything on microsoft site about this. Anyone else wanna take a shot at this?

brendt hess Hall of Fame Points: 3256 More actions · Answer 3

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.

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 4

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

SqlServer Rocking SSChasing Mays Points: 605 More actions · Answer 5

I need small information regarding .tuf file..Where .tuf file is created in sql server ?

manus4u Ten Centuries Points: 1238 More actions · Answer 6

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.

jeet_personal Right there with Babe Points: 765 More actions · Answer 7

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

Suresh B. SSC-Insane Points: 22986 More actions · Answer 8

To bring the database online use following syntax (this also works when .tuf file is missing):

RESTORE <database> WITH RECOVERY

gvram6 SSChasing Mays Points: 645 More actions · Answer 9

how can i restore when TUF file is missing..please help me out