备份时间表 [英] Backup schedule

问题描述

默认情况下，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 ???

推荐答案

Hello,

完整的数据库备份每周创建一次，差异数据库备份通常每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

Alberto Morillo
SQLCoffee.com

这篇关于备份时间表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！