Suppose my Database DB1 lost some data, but I have a Full\Differential backupFull, Differential and then followed by Transaction log backups.
Till full\Differential backup I can understand it is like the snapshot of the database, but after this, how T-log Backup works, if we have point in time recovery.
Means like all the committed transaction from the T-log Backup are taken in a sequence and then after it is performed again on the Database (DB1).
Is this right?
If yes, Is this same is followed during log-shipping, i.e, when logs are shipped from one end to other.
Thanks in Advance.