Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
What is the significance of .TUF file in Log shipping?

One of the user has been confused to see lot of .TUF file within their server where the log shipping is enabled. Basically this .tuf file is the Transaction Undo File, which is created when performing log shipping to a server in Standby mode.

So if you ask why 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. and also refer to this KBA http://support.microsoft.com/kb/308774 about further information.

Posted: Monday, November 12, 2007 11:55 AM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

One of the user has been confused to see lot of .TUF file within their server where the log shipping

# November 12, 2007 3:22 AM

SSQA.net - SqlServer-QA.net said:

One of the user has been confused to see lot of .TUF file within their server where the log shipping

# November 12, 2007 12:04 PM
Anonymous comments are disabled