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

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


Group: General Forum Members
Last Login: Wednesday, November 4, 2015 10:43 PM
Points: 115, Visits: 362

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, November 18, 2015 8:25 AM
Points: 2,381, Visits: 6,834
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