1

Is it correct that performing a transaction log restore to a previous point in time will break the log shipping chain?

If this is correct, is there a way to recover from this situation without having to restore a full backup and re-initialise log shipping on the 2nd server?

0

Is it correct that performing a transaction log restore to a previous point in time will break the log shipping chain?

Any backup restored on primary database will break logshipping and you would have to start from scratch to configure logshipping.

  • Even going back in time down the transactions? Can you not apply the same process to the recovery / standby database to keep it in step? – best Mar 4 '16 at 12:02
  • Sorry I did not got what you are asking – Shanky Mar 4 '16 at 13:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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