且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我如何在系统故障时备份我的数据库

更新时间:2022-02-25 23:51:05

当系统出现故障时,备份就太迟了. 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!