Log Shipping

Question

Log Shipping

Eddy!-427737

SSC Veteran

Points: 270
More actions
July 11, 2007 at 5:53 am

#95229

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

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

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

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

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 Veteran Points: 270 More actions · Answer 2

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 More actions · Answer 3

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 Veteran Points: 270 More actions · Answer 4

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 More actions · Answer 5

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: 577 More actions · Answer 6

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 Veteran Points: 270 More actions · Answer 7

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 More actions · Answer 8

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 More actions · Answer 9

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....

r.sgsits SSC Rookie Points: 25 More actions · Answer 10

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 More actions · Answer 11

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 More actions · Answer 12

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.