I would like to ask a question regarding recovery process while restoring database operation. Let's say I restored a full backup with
NORECOVERY followed by restoring two t-log backups with
NORECOVERY. Lastly, I am going to restore the last 3rd t-log backup with
The question is: when I restore the last t-log backup with
RECOVERY keyword, does SQL Server perform redo as well as undo phases or just does undo phase?
It seems to me that when we restore backup with
NORECOVERY keyword, SQL Server also performs redo phase. The same thing with restoring t-log backups with standby keyword. In this case, SQL Server creates a separate file with the name that contains only "undo" not any "redo".