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 «««1234

Log Shipping Secondary Server Restore problem Expand / Collapse
Author
Message
Posted Tuesday, June 16, 2009 12:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 1:34 AM
Points: 19, Visits: 238
Hi,

I am facing the similar problem with my Log-shipping in sql 2005, with one thing additional, the MSDB database is not getting updated, I do not find any entry in the Log_Shipping_primaries and Log_Shipping secondaries tables on the MSDB? Any workthrough?
Post #735482
Posted Tuesday, December 7, 2010 7:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 28, 2013 12:09 AM
Points: 2, Visits: 91
Hi all,
I've done POC/testing on log shipping using SQL Server 2005, at first, it worked, but sometimes it failed in the recovery job

I just wanna know, what are the matters that caused log shipping failed ?

As far as I know from this topic, these case can caused log shipping failed to restore :
- If any user connect to secondary database (log shipping DB)
- If doing truncate log file on primary database
- If doing backup transaction log on primary database
- any others... ??

And if it failed to restore the transaction log, what should I do ?


Post #1031607
Posted Thursday, August 21, 2014 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 21, 2014 1:32 PM
Points: 9, Visits: 104
I got the same error long time back . I manually restored the log backup and then started the restore job. That fixed the issue.
Post #1605983
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse