July 6, 2011 at 1:57 am
Hi ,
Please someone suggest me , how log file and .TUF file works, if im not wrong , while restoring log on secondary database i.e standby server log file contains(only committed tran) and .tuf file contains(both committed and uncommitted), but how .tuf file contains this uncommitted tran...?
July 6, 2011 at 3:12 pm
from msdn:
'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.'
So if you have log shipping set so the database is in standby mode, the database is made readable by making the data consistent, so any uncommitted transactions are rolled back. Information on those rolled back transactions is kept in the .TUF (transaction undo file).
This way it is still possible to apply the next transaction log backup by using the data in the TUF file as a starting point.
---------------------------------------------------------------------
July 6, 2011 at 11:44 pm
Even t-log carries committed tran and uncommitted tran, but while restoring it restore committed data,(not much concerned of uncommitted data at the time of database crash) is anything particular need of undo files, without undo files can we restore, feeling difficulty to understand as im new to this field
July 7, 2011 at 3:49 am
the undo file is only required in logshipping where the secondary database is restored in the read only, standby mode
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply