Take Tail-Log backup before restore option

Does the SQL server restore the tail-log that backed up after the restoration operation, if I selected the option "Take Tail-Log backup before restore"?

Thanks In Advance

No, it does not restore the tail. The tail BEFORE the restore enables you to restore to the previous full backup and then play all transaction logs back and the last thing it will play back is the tail. This will get you back to the instant just before the bad restore.

StackExchange Database Administrators Q#153477, answer score: 5