备份时间表 | Morillo

本文介绍了备份时间表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

默认情况下，THere将是数据库的每周完整备份.

THere will be weekly full backup for the database by default.

那么什么时候需要备份?

So when it takes the backup ?

星期一?周二?星期三......

monday ? tue ? wed..........

9:00，10:00 ...... ??上午/下午???

9:00, 10:00......?? AM/PM ???

推荐答案

完整的数据库备份每周创建一次，差异数据库备份通常每12小时创建一次，事务日志备份通常每5到10分钟创建一次，频率取决于性能水平和数据库活动量.创建数据库后立即安排第一次完全备份.通常会在30分钟内完成，但可能要花一些时间如果数据库很大，则时间更长"

"Full database backups are created weekly, differential database backups are generally created every 12 hours, and transaction log backups are generally created every 5 - 10 minutes, with the frequency based on the performance level and amount of database activity. The first full backup is scheduled immediately after a database is created. It usually completes within 30 minutes, but it can take longer when the database is of a significant size"

来源: https://docs.microsoft.com/zh-CN/azure/sql-database/sql-database-automated-backups#how-经常做备份

Source:https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups#how-often-do-backups-happen

希望这会有所帮助.

Hope this helps.

问候

Regards,

Alberto Morillo
SQLCoffee.com