I had a question on Log shipping Manual Fail over

Let me explain about environment, Primary Server A (with Cluster setup A-P Mode) Secondary server B(DR server standalone).

We had enabled Log Shipping on a database TEST from Primary Server and now we would like to test by doing a manual fail over and i had few questions.

Log Shipping Jobs are disabled on both A and B Servers and Log shipping is not disabled or removed, Once the Server B is brought online by restoring the all the logs from Server A

  • Can i re-attach/reconfigure the secondary database to existing Log shipping once it is online.
  • I tried using backup with no recovery option on secondary database and log shipping restore jobs are skipping.
  • Is there any method expect role changing can we reconfigure the log-shipping without restoring the database from first?

any references would be appreciated.

Thank You

  • 3
    Related - see my answer at dba.stackexchange.com/a/77429/8783
    – Kin Shah
    Commented Dec 9, 2016 at 13:24
  • I know to do Failover and Failback is there any process if the secondary DB is online, Now i want to take a log backup with norecovery on secondary DB(now it changes to restoring mode) and try to reestablish the log shipping will this work? as i know it will skip the restoration process. Else only process is to build the complete Log Shipping from scratch. Commented Dec 14, 2016 at 9:30
  • Did you see my anwer linked above ? Its exactly what you are looking for.
    – Kin Shah
    Commented Dec 14, 2016 at 11:12
  • Yes I had seen your article. You might not understood my question and I repeat i know to do Failover and Failback of Log shipping what you had discussed in case of Hurricane Sandy is correct. 1) I want to bring the Secondary database online and primary to online and i had removed or not both case is applicable log shipping configuration. 2) Now secondary Db is online and i want to take it to restoring mode using norecovery and i want reinitialize Log shipping on the same DB from primary to secondary is it possible? Is my question clear to you or can i repeat again no failback one failover Commented Dec 14, 2016 at 11:56
  • 1
    Possible duplicate of Disaster Recovery Options for Sql Server Commented Apr 22, 2019 at 0:59

1 Answer 1


If i understand correctly, you want to reinitialize log shipping from B to A?

If yes, then once you bring the DR site database (B) online you automatically break the LSN chain hence the restore log files will be skipped. The only way to reestablish log shipping is to remove log shipping setup completely, create backup of database B, restore at database A in stand by/readonly and then setup log shipping from B.

  • If i understand correctly, you want to reinitialize log shipping from B to A? No I know to do Failover and Failback in Logshipping(A -> B and B -> A), I want the Server B to be online and check it is online (ensure Failover is done) Now i want again Server B to be reinitialized for Log shipping(A -> B only) process without reestablish of Log shipping from Server A to Server B from scratch as it's a large sized database. Commented Dec 14, 2016 at 5:15

Not the answer you're looking for? Browse other questions tagged or ask your own question.