Hanshi I executed your query on Sample Database.. below is the output

database_name backup_finish_date type first_lsn database_backup_lsn physical_device_name

-------------------------------------------------------------------------------------------------------------------------------- ----------------------- ---- --------------------------------------- --------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

A 2013-08-20 02:00:20.000 D 24000000014800179 0 E:\A_Full.bak

A 2013-08-20 02:02:26.000 L 24000000014800179 24000000014800179 E:\A_Tran.trn

A 2013-08-20 02:03:14.000 D 24000000027900076 24000000014800179 E:\A2_Tran.trn

(3 row(s) affected)

====

Now please tell me the restoration step with details.. like standy by or no recovery or etc..