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 T ransaction U ndo F ile, 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....(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/11/12/what-is-the-significance-of-tuf-file-in-log-shipping.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2729" width="1" height="1">