首先完全恢复但norecovery
restore database orders
from order_fullback
with norecovery
然后通过日志来恢复到你要的时点
use master
go
restore log orders
from disk ='d:\rock\back_log_20040313'
with recovery,
stopat = '2004-04-13 9:45:00'
restore database orders
from order_fullback
with norecovery
然后通过日志来恢复到你要的时点
use master
go
restore log orders
from disk ='d:\rock\back_log_20040313'
with recovery,
stopat = '2004-04-13 9:45:00'