Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Log Shipping Expand / Collapse
Author
Message
Posted Wednesday, July 11, 2007 5:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 1, 2007 4:55 AM
Points: 8, Visits: 2

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

Post #380627
Posted Wednesday, July 11, 2007 5:55 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:39 AM
Points: 3,461, Visits: 350
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
Post #380628
Posted Wednesday, July 11, 2007 7:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 1, 2007 4:55 AM
Points: 8, Visits: 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

Post #380668
Posted Friday, July 13, 2007 2:18 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:39 AM
Points: 3,461, Visits: 350
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
Post #381377
Posted Monday, July 16, 2007 2:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 1, 2007 4:55 AM
Points: 8, Visits: 2

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

Post #381835
Posted Monday, July 16, 2007 4:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:39 AM
Points: 3,461, Visits: 350
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
Post #381856
Posted Thursday, July 26, 2007 9:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 21, 2010 2:40 PM
Points: 19, Visits: 57

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.

Post #385645
Posted Friday, July 27, 2007 1:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 1, 2007 4:55 AM
Points: 8, Visits: 2

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.

Post #385678
Posted Tuesday, October 23, 2007 10:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 1:40 PM
Points: 22, Visits: 17
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?


Post #414016
Posted Friday, October 24, 2008 2:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 2:51 PM
Points: 24, Visits: 334
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
Post #591526
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse