Log Shipping

  • Eddy!-427737

    SSC Enthusiast

    Points: 170

    Hi,

    Does anyone know of a way to recover log shipping with a missing tuf file.  long story why the tuf file is missing but it cannot be replaced.

    The only way i can see now is by setting up log shipping from scratch again.

    thanks in advance

    Dave

  • Sugesh Kumar

    One Orange Chip

    Points: 27311

    Check what is the last restored file in the secondary server. Then copy all files from the primary server to the destination file and start the restore job so that those files will be restored again try this before you reconfigure logshipping.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Eddy!-427737

    SSC Enthusiast

    Points: 170

    Sugesh,

    Thanks for the suggestion but it is still looking for the tuf file that no longer exists.

    I get an error: Server: Msg 3441, Level 17, State 1, Line 2

    thanks,

    Dave

  • Sugesh Kumar

    One Orange Chip

    Points: 27311

    The tuf is Transaction Undo File that will be used to remove uncommited data. if my suggestion does not help then go ahead and reconfigure logshipping.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Eddy!-427737

    SSC Enthusiast

    Points: 170

    Thanks Sugesh, i had to restore to the secondary server in the end and reconfigure log shipping.

    I was trying to have an OLAP server and DR server with one copy location for the logs but different restore times, doing this only creates one tuf file so i now have 2 copy locations for the logs and working a treat....another lesson learnt in the world of Log Shipping

    thanks again

  • Sugesh Kumar

    One Orange Chip

    Points: 27311

    Good that you have implemented the copy job across two locations so that even if it fails in one location it will be available in the other a case of high availability.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Ammad Baig

    Mr or Mrs. 500

    Points: 517

    I am configuring the log shipping and getting the same error:

    "During startup of warm standby database <db_name> (DB ID 5), its standby file (C:\windows\system32\<db_name_20070727025522.TUF)was inaccessible to the Restore statement. The OS system err was 5 (Access is denied). Diagnose the OS error, correct the problem and retry startup. (MS SQL ERR: 3441)."

    The svc account running SQL Server and agent is in the admin group on the server.

    Any ideas?

    Thanks.

  • Eddy!-427737

    SSC Enthusiast

    Points: 170

    Ammad,

    Have you double checked that the tuf file exists in the location specified in the error and the time on it is around the same of the last restored log?  The problem i had was introducing another secondary server to be log shipped to which corrupted the tuf file and i had to reinstate log shipping.

  • GBlackwell

    SSC Rookie

    Points: 38

    I'm having the same problem with the TUF file. It is attemptig to write it to C:\Windows\System32, but apparently cannot access that folder. Any idea why it's selecting C:\Windows\System32 or how I select a different location?

  • eduardo.pin

    SSC Eights!

    Points: 996

    Hi,

    I´m on the same trouble.

    My operations team have deleted a .tuf file form one of my logshiping servers.

    My trouble is bigger than usually do because my database has 2.5 Tera Bytes so I gonna take 3 days to recevery it at least.

    I did the same thing (deleted .tuf file) in a controlled server, and try to recover some logs without the .tuf file, but didn´t work in any way.

    Let me know if somebody has solved this trouble without restart the whole logshiping processes.

    Regards....

    Pin

  • r.sgsits

    SSC Rookie

    Points: 25

    Sugesh,

    I am small doubt..i hv copied the tuf file in 2 location but my one original tuf file is updating in every 15Min(log is applying) this info is not updating in secondary tuf file coz i have made the copy in time when i configured the logshipping..

    now someone has deleted the primary tuf file if i copy the older tuf file to primary location will it work ???

    reagrds

    sgsits

  • swaraj.saini

    Grasshopper

    Points: 10

    you can not place old TUF file because each and every time when database get restored in Standby mode it Uses that Tuf file and Recreate it . because tuf file stands for Transaction Undo file it holds all the redo undo data related to transaction of current Restoration Trn file

  • HARIANGEL

    SSC Enthusiast

    Points: 173

    If tuf file missing makes logshipping does not work properly. Why can't we just take the full backup and restore on secondary and start the functionality as usual.

    Let me know if it does not help much.

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply