You may want to restore the database to an earlier point in time than to the point of failure. For example, an earlier transaction within a database changed some data incorrectly, but the transaction was committed, and several transaction log backups have been created afterward. Therefore, you will need to restore the database backup and only those transaction logs that contain the changes prior to the transaction you do not want applied.
用日志恢复:
restore log {data_name|@database_name_var}
from <log_file>
with [norecovery\recovery\standby_undo_file_name]
[,][stopat={data_time|@data_time_var}
例如:库名为database1 日志为database1_log 要求恢复2000/6/15 1:00前的数据:
restroe log database1
from database_log
with recovery,stopat='jun 15,2000 1:00 am'