SQL SERVER中的灾难恢复 [英] Disaster Recovery In SQL SERVER

问题描述

大家好，

在发生灾难时的计划是什么:

"我有一个sql服务器数据库，其备份计划为:每天12:00 AM进行完全备份，每2小时进行一次Diff备份，每1小时进行一次日志备份，这是自动计划.在3:40 AM进行，到XYZ原因灾难在SQL Server数据库中发生"

I am having one sql server database with backup plan of FULL Backup on 12:00 AM Daily and Diff Backup after every 2 Hours and Log backup after every 1 hour and that is auto schedule. At 3:40 AM , due to XYZ reason the disaster happen in sql server database "

解决方案

Hi Dr,
I think the recovery plan should be like this :
First restore the full backup of 12:00AM then restore the last differential backup which was happened at 2:00AM and then restore the log backup which was happened at 3:00AM and the data which was manipulated between 3:00AM and 3:40AM is probably lost forever :( (except when you are able to restore database files). And all of this was based on this assumption that all of 3 backup jobs was started at the 12:00AM.

这篇关于SQL SERVER中的灾难恢复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！