Wednesday, January 23, 2013 4:30 PM
We are using log-shipping with standby option, backups are schedules at 15 min but we are only applying logs at secondary site every 2 hours so do SQL Server create undo file after applying every log file or it have enough information to apply all the 8 log files and then generate the undo file for the last(8<sup>th</sup>) file. Also undo file supposed to be in copy directory but somehow I can’t see it, any other default location for .tuf(undo) file when using log-shipping in standby mode?
Wednesday, January 23, 2013 5:48 PM
I just created a test one to see how it goes and I see that
an undo file(.tuf) will be created for each restoration and once the restoration is completed it will replace the previous
undo file with the new one(as the previuous one is not needed). So, when restore job finishes, you will be left with only one .tuf file.
In my case, the tuf file was created on the data directory(mdf file directory) of the destination database
Hope it Helps!!
Thursday, January 24, 2013 5:13 AM
Your SQL server agent will take care that. As long as your files are copied to the folder from where your agent on secondary pick up.
It is not a problem to load all files available to restore at secondary.
Check this link to get better understanding why .tuf file is used.