To do this , configure a new backup job or select the existing backup . the backup type should be specified transaction log backup . See following picture :
How to restore database to the point of failure?
If your database's recovery modal is "Simple" , you can not restore to the point of failure , in this case , please select the latest differential and full backup do the restore.
If your database's recovery modal is not "Simple" , Please follow steps below to restore database to the point of failure :
1) Back up the tail of transaction log after SQL Server fails . (Key
step)
To do this , configure a new backup job or select the
existing backup . the backup type should be specified transaction log backup .
See following picture :
If your server is not a MS SQL Server 7.0 , you can also select "Back up the tail of the log , and leave the database in the restoring state" option .
2) Make a restore job using this transaction log backup.