誤用delete了，怎么根據日誌恢復？

[hdyd]

---------------------------------------------------------------------*/

declare @vDB_Name varchar(128)
declare @vDB_NameWithPath varchar(128)
declare @vDB_StopAt varchar(128)

select @vDB_Name='abc'
select @vDB_NameWithPath='abc'
select @vDB_StopAt='2003/5/19 08:30:00'

backup log @vDB_Name to disk=@vDB_NameWithPath

restore database iac_hr_data from disk='D:\abc' with norecovery

restore log @vDB_Name from disk=@vDB_NameWithPath with stopat=@vDB_StopAt



執行上面的
出現下面的錯誤：
Server: Msg 3135, Level 16, State 2, Line 2
The backup set in file 'D:\abc' was created by BACKUP LOG and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

[pengdali]

restore log abc from disk='D:\abc' with stopat='2003/5/19 08:30:00'

这个d:\abc是你的最新备份。

[hdyd]

就是說，沒有指望恢復了？

[hjb111]

用Log Explorer根据事务日志恢复吧！

[TomKen]

好东西啊

[happydreamer]

log explorer可以恢复的