2

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.

2
  • 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

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