我如何在系统故障时备份我的数据库 [英] how can i back up my database at system failure

问题描述

我想在断电的情况下备份我的数据库
我可以进行正常的备份，但是我也需要在系统故障时适应系统.

hi i want to back up my data base incase of power failure
i can do the normal back up but im required to also accomodate the system on system failure

推荐答案

当系统出现故障时，备份就太迟了. br/> 您需要对此进行计划，并确定可以预期损失多少数据.
阅读此 [ ^ ]关于Microsoft SQL Server的灾难恢复选项.

When you have a system failure it is to late for a backup.
You need to plan this and decide on how much loss off data is expectable.
Have a read through this[^] about the disaster recovery options for Microsoft SQL Server.

当系统发生故障时，它不会等待以便完成备份.您需要为业务开发SLA(服务水平协议).

一旦制定了SLA，您将知道何时设置备份！在我工作的地方，我们每4小时进行一次增量备份，每天进行完整备份.

但是请确保您也定期测试备份！

When the system fails it fails it doesn''t wait for a backup to finish. You need to develop your SLA (service level agreements) for the business.

Once the SLA is worked out you''ll know when to set backups for! Where I work we do incremental backups every 4 hours and full backups everyday.

BUT make sure you test your backups regulary also!

这篇关于我如何在系统故障时备份我的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！