restore database Personnel from disk='[完整备份]' with no norecoveryrestore database Personnel from disk='D:\Backup\Personnel.bak' with no recovery楼主执行的是以上的语句还原数据库的吗?提示什么?
不好意思,以上打错,正确是restore database Personnel from disk='[完整备份]' with norecoveryrestore database Personnel from disk='D:\Backup\Personnel.bak' with recovery
用这个还原的话还是还原到很久以前的备份啊,从以前备份到坏掉的操作都没法还原了么? 用这个backup log Personnel to disk='D:\Backup\Personnel.bak' with no_truncate命令不能备份当前日志状态么?
先查看一下Personnel.bak里含有几个备份集. restore headeronly from disk='D:\Backup\Personnel.bak'然后restore时指定备份集, restore database Personnel from disk='D:\Backup\Personnel.bak' with file=[备份集序号],recovery
restore时指定日志备份的备份集, restore headeronly结果的Position字段.restore database Personnel from disk='D:\Backup\Personnel.bak' with file=[备份集序号],recovery
restore database Personnel from disk='[完整备份]' with no norecoveryrestore database Personnel from disk='D:\Backup\Personnel.bak'
with no recovery楼主执行的是以上的语句还原数据库的吗?提示什么?
with recovery
用这个还原的话还是还原到很久以前的备份啊,从以前备份到坏掉的操作都没法还原了么?
用这个backup log Personnel to disk='D:\Backup\Personnel.bak' with no_truncate命令不能备份当前日志状态么?
restore headeronly from disk='D:\Backup\Personnel.bak'然后restore时指定备份集,
restore database Personnel from disk='D:\Backup\Personnel.bak'
with file=[备份集序号],recovery
restore headeronly结果的Position字段.restore database Personnel from disk='D:\Backup\Personnel.bak'
with file=[备份集序号],recovery