用 LogExpoler 连接到数据库后,弹出提示 waring:log contains recycled data only! your log contains only recycled data this data exists temporarily until SQL server overwrites it with new information. this condition is due to one of the following reasons: your log has truncate log on checkpoint option set to true your database has never been backed up your log was truncated by dump transaction with no_log 这是什么原因?
选择数据库->attach->左面对话框中browse->view log->就可以看到log记录,
点击“View DDL Commands”里面就有很多drop table 命令
点击下面的“undo”按钮是生成表结构的语句(create table ....)
点击下面的“Salvage”按钮是生成插入语句的(insert into ...values....)
注意:在恢复事务日志时,恢复到某一个时刻(即在执行Convert操作之前)即可。
waring:log contains recycled data only!
your log contains only recycled data
this data exists temporarily until SQL server overwrites it with new information.
this condition is due to one of the following reasons:
your log has truncate log on checkpoint option set to true
your database has never been backed up
your log was truncated by dump transaction with no_log
这是什么原因?
希望高手给予解答!现在我能做的,就是帮你把帖子顶上去了...
then f1如果你表里面有trigger 要小心