誤用delete了,怎么根據日誌恢復?
hdyd 2003-08-21 08:31:25 ---------------------------------------------------------------------*/
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.