BACKUP LOG erpdb1 TO disk= N'd: estBkErp.db' WITH NORECOVERY
RESTORE DATABASE erpdb1 FROM DISK = N'e:erpdb1201501130800.bak' WITH NORECOVERY, REPLACE
RESTORE LOG erpdb1 FROM DISK = N'd: estBkErp.db' WITH STOPAT = N'2015-01-16 10:13:29.320' , RECOVERY
select getDate()
三步执行完成后,要从备份中恢复过来
restore database XXX with recovery
RESTORE DATABASE erpdb1 WITH recovery