Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Log Shipping after recovery steps? Expand / Collapse
Posted Wednesday, August 11, 2010 3:09 AM


Group: General Forum Members
Last Login: Monday, October 17, 2016 3:10 AM
Points: 115, Visits: 391

I have also implemented Log shipping according to your document on 110 GB database. Now i am worried when primary server fail we will restore Secondary server with “no recovery option” and suppose after 2 days primary server is up till that time my secondary server act as primary server.
But when my primary server is ok i need it back in action.
My Question is do we need to follow same action again to establish log shipping or is there any other way.

Post #967243
Posted Wednesday, August 11, 2010 1:05 PM



Group: General Forum Members
Last Login: Wednesday, October 19, 2016 7:19 AM
Points: 2,382, Visits: 6,850
With minimum downtime you want to bring Server A (primary) back online, Set the log shipping from Server B to A. And then do a No recovery. After that you will have to reset the Log shipping from A to B again from the scratch.

Post #967773
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse