GilaMonster (2/6/2013)
even then a diff backup's usually easier.
Providing a full backup hasn't occurred since the LS plan broke otherwise the Differential_Base_LSN is incremented and the Diff will no longer be restorable on the secondary.
sotn (2/7/2013)
That is where I am confused, as I thought that a FULL backup which does not perform a Tlog backup as such, does affect the transactions so there is no tlog backup file to copy and the next tlog backup at 07:00 will only have transactions since the full backup and not since the last tlog backup at 21:00.I guess within log shipping it is intelligent enough to identify transactions in the full backup to copy without a normal tlog bak file.
Do you understand the principals of log shipping?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉