In short: First do RESTORE DATABASE using the keyword WITH NORECOVERY Then do RESTORE LOG with the different log backups that should be included. When you come to the log backup which contains the point in time you want to restore to, you add the keyword STOPAT='2012-11-18 12:31:29.000' (or whatever time you want to use). You should use keyword WITH NORECOVERY also for each of these log restores. Last, issue RESTORE DATABASE dbname WITH RECOVERY That's a very compressed walk through. You could also use Management Studio to get some GUI help for this. Books Online about RESTORE:
http://msdn.microsoft.com/en-us/library/ms186858.aspx Books online about Point In Time restore
You can use the GUI to restore your full, differential and specify all available transaction logs. That would bring you up to the most recent point in time of your latest transaction log. If you want to specify a specific point in time such as 12:13 PM and your last log was taken at 12:15 PM then you could chose the STOP AT option in the GUI and specify the time and seconds to stop restoring at. Any transactions completed as of 12:13 would be restored. You can also specify STOP AT in TSQL and accomplish the same task. Is this what you are looking for? +1 for testing your recovery plan.
So to test point in time recovery, pick a point in time and see if you can recover to it. That point in time could represent a disaster or some other event that changed the database. You can mimic total loss by trying to restore the whole database installation onto separate hardware, or less catastrophic scenarios by restoring back onto the target server, although don't attempt this on a live server without permission!
First thing, make sure that you have your database set up on Full Recovery model On Simple recovery model, there is no transaction log which means, there is no point in time recovery. so set up your database on full recovery mode. Take full backup, Take differential backup (not necessary) take Transaction log backup. you can only do "point in time" or "point of failure " from transaction log backup then 1) restore tail log backup 2) Restore full backup 3) Restore transaction log backup up ( the log is the serial recording of every transaction, restore the log as per the time it occurs. keep the sequence of the log, when you restore) Hope this is helpful Mulu