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

Redo log shipping when secondary database not in recovery mode Expand / Collapse
Author
Message
Posted Monday, December 09, 2013 3:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 17, 2014 10:05 PM
Points: 83, Visits: 201
I just took over as dba, and I see the secondary database is not in recover mode, therefore the logshipping proccess is failing. Is there any way I can put it in recovery mode or should I just restart the whole log shipping proccess.
Thanks
Post #1521321
Posted Tuesday, December 10, 2013 3:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:08 AM
Points: 1,350, Visits: 15,200
Is the db online? If it is, there is no way to revert the db to logshipping as it has fully recovered. You will need to restart by restoring a recent backup using NORECOVERY or STANDBY.

You can restore transaction logs to a db when it is in stand by or recovering.
Post #1521430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse