有关备份的问题 [英] Have a Q about back up

问题描述

HelllOOOOOo所有;):

我有一个关于备份的问题，假设我有一个数据库，包含70多个用户，例如，我在凌晨2:00进行了一次备份，之后有20个用户(随机)进行了一些备份.更改，例如，在凌晨3:00，硬盘中存在一个坏扇区，因此，如果我想再次查看对20个用户所做的更改，我该如何将它们退回?有什么策略吗?

在此先感谢，感谢您的答复:)

HelllOOOOOo All ;) :

I''ve a qustion about back up , lets assume that I''ve a Data Base , contains more than 70 users , and I made a back up for example in 2:00 am, after that 20 users(randomly) made some changes ,then in 3:00 am for example there was a bad sector in Hard Disk , so if I want to reurn the changes that have made for 20 users , how can I return them back ? is thier any strategy?

Thanks in Advance, I appreciate any reply :)

推荐答案

冷数据库备份

在冷备份期间，数据库已关闭或锁定，并且用户无法使用.数据文件在备份过程中不会更改，因此当数据库恢复正常操作时，数据库将处于一致状态.

热数据库备份

一些数据库管理系统提供了一种在数据库联机且可用(热")时生成数据库备份映像的方法.这通常包括数据文件的映像不一致，以及过程运行时所做的更改日志.还原后，将重新应用日志文件中的更改以使数据库同步.

我想您需要阅读有关热"数据备份的更多信息.

Cold database backup

During a cold backup, the database is closed or locked and not available to users. The datafiles do not change during the backup process so the database is in a consistent state when it is returned to normal operation.

Hot database backup

Some database management systems offer a means to generate a backup image of the database while it is online and usable ("hot"). This usually includes an inconsistent image of the data files plus a log of changes made while the procedure is running. Upon a restore, the changes in the log files are reapplied to bring the database in sync.

I guess you need to read more about ''Hot'' data backups.

这篇关于有关备份的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！