-- Full restore to point of failure
-- From BOL
-- See http://msdn2.microsoft.com/en-us/library/ms175093.aspx

--Backup the tail end of the log
BACKUP LOG <database_name> TO <backup_device>
   WITH NORECOVERY, NO_TRUNCATE;

-- Restore from full backup
RESTORE DATABASE <database_name> FROM <backup_device>
   WITH NORECOVERY;

-- Optionally restore from differential backup
RESTORE DATABASE <database_name> FROM <backup_device>
   WITH NORECOVERY;

-- Sequentially restore each transaction log backup from the full backup
-- through the tail log backup
RESTORE LOG <database_name> FROM <backup_device>
   WITH NORECOVERY;

-- Recover the database
RESTORE DATABASE <database_name>
   WITH RECOVERY