What is .TUF file? What is the
significance of the same? Any implications if the file is deleted?
.TUF file is the Transaction Undo File, which is created when
performing log shipping to a server in Standby mode.
When the database is in Standby mode the database recovery is done when the log is restored; and this mode also creates a file on destination server with .TUF extension which is the transaction undo file.
When the database is in Standby mode the database recovery is done when the log is restored; and this mode also creates a file on destination server with .TUF extension which is the transaction undo file.
This file contains
information on all the modifications performed at the time backup is taken.
The file plays a important
role in Standby mode… the reason being very obvious while restoring the
log backup all uncommited transactions are recorded to the undo file with
only commited transactions written to disk which enables the users to read the
database. So when we restore next transaction log backup; SQL server will fetch
all the uncommited transactions from undo file and check with the new
transaction log backup whether commited or not.
If found to be commited the
transactions will be written to disk else it will be stored in undo file until
it gets commited or rolledback.
I'm really enjoying the design and layout of
ReplyDeleteyour site. It's a very easy on the eyes which makes
it much more pleasant for me to come here and visit more often. Did you
hire out a designer to create your theme? Exceptional work!
My webpage - https://www.facebook.com/LeagueofAngelsHackCheat
Hello there! This is my first visit to your blog! We are a collection of volunteers and starting a new project in a community
ReplyDeletein the same niche. Your blog provided us valuable information to work on. You
have done a outstanding job!
Feel free to surf to my blog - magento themes