sql server 2008 r2还原数据库到指定的时间点
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_04.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_06.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_08.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_10.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_12.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_14.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_16.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_18.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_20.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_29_22.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_30_00.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_30_02.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_30_04.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student1\student_backup_2018_04_30_06.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_08.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_10.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_12.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_14.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_16.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_18.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_20.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_04_30_22.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_05_01_00.trn'
with norecovery
restore log student_backup_201804290200
from disk = 'D:\log\student2\student_backup_2018_05_01_02.trn'
with recovery,STOPAT= '2018-05-01 02:00:00'

浙公网安备 33010602011771号