从最后一个还原点还原数据库 [英] Restore database from last resotre point

问题描述

Azure是否具有功能/功能，其中数据库的备份会自动进行并保存在服务器上，可以由我们导入.实际上，来自特定表的数据已被意外替换.我们必须紧急恢复该数据.

Does Azure have feature/functionality in which backup of database is automatically taken and kept on server, which can be imported by us. Actually, data from a particular table has been replaced accidently. We have to restore that data on urgent basis.

推荐答案

Azure是否具有自动备份数据库并保存在服务器上的功能?可以由我们进口.实际上，来自特定表的数据已被意外替换.我们必须在紧急情况下恢复该数据 基础.

Does Azure have feature/functionality in which backup of database is automatically taken and kept on server, which can be imported by us. Actually, data from a particular table has been replaced accidently. We have to restore that data on urgent basis.

>>  Azure是否具有自动备份数据库并保存在服务器上的功能/功能

>> Does Azure have feature/functionality in which backup of database is automatically taken and kept on server

所有Azure SQL数据库均自动备份，无需额外费用，您可以根据需要使用时间点来还原数据库.

All Azure SQL databases are backed up automatically with no additional charge, and you can use point in time to restore the database if needed.

您可以在此处阅读有关该主题的更多信息:
https://docs.microsoft.com/en -us/azure/sql-database/sql-database-automated-backups

You can read more about the topic here:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups

>>  可以由我们导入

>> which can be imported by us

如果需要导入/导出，则自动备份不提供内置解决方案，您需要使用任何导入/导出数据库解决方案.您可以使用Azure自动化之类的工具来像其他任何过程一样自动化该过程

If you need to import/export then automatically backup does not provide built-in solution and you need to use any of the import/export databases solution. You can automate this procedure like any other procedure using tools like Azure automation

>>  实际上，特定表中的数据已被意外替换.

>> Actually, data from a particular table has been replaced accidently.

您可以使用 内置还原到特定的时间点.

You can use the built-in restore to specific point in time.

>>  我们必须紧急恢复该数据.

>> We have to restore that data on urgent basis.

如果这不是一次案例，那么听起来您应该做点其他事情！我不建议您辞退负责系统设计的人员，但您应该认真考虑一下系统架构，因为这没有道理

If this is not a one time case then it sound like you should do something else! I would not not recommend to fire the person who in-charge on your system designed yet, but you should surly re-think about your system architecture since this make no sense

这篇关于从最后一个还原点还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！