How to do a Tail Log backup of a database with NoRecovery in SQL Server

We can use RESTORE statement as following

RESTORE LOG SampleDB
FROM DISK = C:\SampleDB.BAK'
WITH File = 3, RECOVERY

Next Recommended Reading How To Backup All Databases In SQL Server