对于数据库来说,什么是“恢复”?什么是“恢复”?
恢复
和恢复
有什么区别?我的理解是:
恢复:使用以下命令刷新数据库 该数据库的备份文件
恢复:数据库失败后, 比如重启服务器, 数据库重新应用提交的 事务日志中的事务
我的理解对吗?
谢谢,
What's the difference of restore
and recovery
? What I understand is:
restore: refresh a database using the
backup files of this databaserecovery: after the database fail,
such as the reboot the server, the
database reapply the committed
transaction in the transaction log
Does my understanding right?
Thanks,
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
恢复;从备份介质(例如磁带、其他磁盘)取回文件
恢复;重新运行或展开数据库中部分完成的正在进行的事务。
一般情况下会恢复,然后恢复。一些 RDBMe 会在某种程度上隐藏这 2 个不同的步骤,但仍然执行这 2 个不同的操作。
Restore; bring a file back from backup media, e.g. tape, other disk
Recovery; re-running or unwinding in progress transactions that were partly completed in the DB.
Generally one will recover and then restore. Some RDBMes will hide the 2 different steps to some extent but still undertake the 2 different actions.
它们的功能相同,可以恢复意外删除的记录、修复损坏的数据库文件、恢复整个表以及查询、表单、宏和存储过程。
They are the same function, bringing back records that were accidentally dropped, repair corrupted database files, restore entire tables as well as queries, forms, macros, and stored procedures.