Okk..

Why just the last log has to be restored? Not the logs before that??

Assume, i have a full backup nightly and have transaction logs every 15 during day time.

Then, if i want to restore the database at any time during day, then i should restore the last .bak file

and then all the transaction logs since the backup time to the last transaction log sequentially...

Is it fine?

Regards,

Sushant