To restore database to a point in time , please select "Only transaction log records written before the specified date and time are applied to the database" option when make a restore job .
If the transaction log
backup does not contain the requested time (for example,
if the time specified is beyond the end of the time covered by the transaction
log), the database remains unrecovered . In this case , to bring up
database , please make a new job with following setting:
1 . Do not select any backup .
2 . Keep "Disable auto-select"
checked .
3 . Set the "Recovery Completion State" to "Database is
brought up and ready for use" selection.
4 . Run this job.