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