log explorer 提示:no log data found for this database
方法1在網上找恢復物理文件的軟件方法2 這樣試試 用一台機,還原10天前備份 BACKUP LOG db TO DISK='c:\日誌文件.bak' WITH FORMAT,NO_TRUNCATE RESTORE DATABASE db FROM DISK='c:\10天前備份.bak' WITH NORECOVERY RESTORE LOG db FROM DISK='c:\日誌文件.bak' WITH RECOVERY
我现在就很奇怪,为什么通过这样删除的bak文件为什么不能通过软件来恢复
恢复前几天的数据了 --备份数据库文件 backup database to disk='d:\数据库文件.bak' backup log to disk='d:\日志文件.bak' ---备份数据库日志 restore database to disk='d:\数据库文件.bak' restore log to disk='d:\日志文件.bak'
修改楼上 backup database db to disk='d:\数据库文件.bak' with format backup log db to disk='d:\日志文件.bak' with format---备份数据库日志 restore database db to disk='d:\数据库文件.bak' with recovery restore log db to disk='d:\日志文件.bak' with NOrevery
网上查到一些贴子说log explorer可以解决 但是附加时提示:no log data found for this database一直找不到原因和解决办法
估计要花RMB找专业公司了
這樣試試
用一台機,還原10天前備份
BACKUP LOG db TO DISK='c:\日誌文件.bak' WITH FORMAT,NO_TRUNCATE
RESTORE DATABASE db FROM DISK='c:\10天前備份.bak' WITH NORECOVERY
RESTORE LOG db FROM DISK='c:\日誌文件.bak' WITH RECOVERY
--备份数据库文件
backup database to disk='d:\数据库文件.bak'
backup log to disk='d:\日志文件.bak'
---备份数据库日志
restore database to disk='d:\数据库文件.bak'
restore log to disk='d:\日志文件.bak'
backup database db to disk='d:\数据库文件.bak' with format
backup log db to disk='d:\日志文件.bak' with format---备份数据库日志
restore database db to disk='d:\数据库文件.bak' with recovery
restore log db to disk='d:\日志文件.bak' with NOrevery