My log Shipping got Broken. When Can i use Differntial backup to do the restore and when Can I not use differntail backup?

Question

My log Shipping got Broken from Server A to B

When Can i use Differential backup to do the restore and when Can I not use differential backup?

I have Full backup Once a week Sunday at 8 pm

I have differential backup Monday- Saturday at 8 PM

Log Shipping went out of Sync from 9 pm on Monday.

Have differential backup from 8 Pm on Monday. Missing log backups from 8:30 to 9:00 Pm.

How do I get this to sync?

Answer 1

Since it is Sunday, why just start over with the full backup? I don't know where you are located, but in my part of the world, we are past 8 pm. If you are located further west, the easiest may be to wait a couple of hours.

But say that you discovered this on a Thursday and wanted to re-init. Then you would first restore the full backup from Sunday and apply the diff backup from Wednesday, and the apply the log backups.

Here I am assuming that you are tearing down the current log shipping and set up again.

If you could apply a diff backup to the current log-shipping database? In that case you would take the diff backup from Saturday, but I don't know if this will work or not. But my gut feeling is that it will not, but you can try. The worst thing that can happen is that you get an error message.

Just to clarify: If you have a full backup and a number of diff backups, you only need to restore the most recent diff backup. This is different from log backups where you need to restore each and every one of them.

Answer 2

Hi @Pandey, Birendra,

First you may restore the full and the diff back up in 8pm.You'll need to manually copy the transaction file from the server A to server B during 8:30 to 9:00 Pm.

Restore a Transaction Log Backup (SQL Server)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.