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

问题描述

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

Alberto Morillo
SQLCoffee.com


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

08-11 13:27