Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server Developer Center >
> 
> 
Log shipping with Standby option

Answered Log shipping with Standby option

  • Wednesday, January 23, 2013 4:30 PM
     
     
    Sign In to Vote
    0

    Hi,

    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?

    Thanks

    --Harvinder


     

All Replies

  • Wednesday, January 23, 2013 5:48 PM
     
     Answered
    Sign In to Vote
    1

    Hello Harvinder,

    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
     
     Answered
    Sign In to Vote
    0

    Hi there,

    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.

    http://rajbaraty.wordpress.com/2011/12/19/understanding-tuf-file-in-log-shipping/

    Good luck

    kumar