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

Bring Secondary Log Shipping DB online WITHOUT .TUF file Expand / Collapse
Author
Message
Posted Thursday, July 24, 2014 2:17 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 6:40 PM
Points: 319, Visits: 805
So if you have a database out of sync with its primary and you have lost the .TUF and old log files. Is there a way to fix log shipping? spend the last 20 mins looking for an answer, my plan was to bring the secondary online, then do a full restore of a new bkacup of the primary. But of course im running into the

RESTORE database [myDB]
WITH RECOVERY

results in

Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3441, Level 17, State 1, Line 1
During startup of warm standby database 'myDB' (database ID 13), its standby file ('X:\Logs\myDB_20140723080008.tuf') was inaccessible to the RESTORE statement. The operating system error was '2(error not found)'. Diagnose the operating system error, correct the problem, and retry startup.


Im guessing the solution is remove log shipping and set it up again?
Post #1595808
Posted Thursday, July 24, 2014 2:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:40 AM
Points: 499, Visits: 1,823
Yes, just set it up again from scratch. It's probably going to be quicker.
Post #1595810
Posted Thursday, July 24, 2014 2:22 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 6:40 PM
Points: 319, Visits: 805


thought so.

thanks for the quick reply..
Post #1595811
Posted Thursday, July 24, 2014 4:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:38 PM
Points: 6,350, Visits: 13,675
don't ever delete the TUF file, this will require a re initialisation of the LS plan

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1595836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse