TO ROBOT和sSam: 不知解决过这种问题没有??如果有,就说出来!好象不是很简单的!!!!!!!!!!!!!! 事物已经提交了,我不知怎么办了,我对这问题很有兴趣,什么参考书?? 我在books online就是找不到!!!
用日志恢复: restore log {data_name|@database_name_var} from <log_file> with [norecovery\recovery\standby_undo_file_name] [,][stopat={data_time|@data_time_var}例如:库名为database1 日志为database1_log 要求恢复2000/6/15 1:00前的数据: restroe log database1 from database_log with recovery,stopat='jun 15,2000 1:00 am'参考书有:<SQL SERVER7.0 系统管理和应用开发指南>(清华大学出版
You may want to restore the database to an earlier point in time than to the point of failure. For example, an earlier transaction within a database changed some data incorrectly, but the transaction was committed, and several transaction log backups have been created afterward. Therefore, you will need to restore the database backup and only those transaction logs that contain the changes prior to the transaction you do not want applied.
不知解决过这种问题没有??如果有,就说出来!好象不是很简单的!!!!!!!!!!!!!!
事物已经提交了,我不知怎么办了,我对这问题很有兴趣,什么参考书??
我在books online就是找不到!!!
restore log {data_name|@database_name_var}
from <log_file>
with [norecovery\recovery\standby_undo_file_name]
[,][stopat={data_time|@data_time_var}例如:库名为database1 日志为database1_log 要求恢复2000/6/15 1:00前的数据:
restroe log database1
from database_log
with recovery,stopat='jun 15,2000 1:00 am'参考书有:<SQL SERVER7.0 系统管理和应用开发指南>(清华大学出版