Log Backup Frequency 策略 - SQL Server

Posted by: bart30508 | in SQL Server, database | 8 months, 3 weeks ago |

15~30分鐘一次是Microsoft官方文檔的一段話(建議).

Taking a log backup every 15 to 30 minutes might be enough.

我認為Backup Log頻率不能太低(30分鐘有點低)的理由有幾個:

  1. Backup Log的頻率關係到是否要頻繁的壓縮LOG,因為Backup LOG能使LOG FILE空間可重用,也就不那麼容易撐滿LOG DISK
  2. 頻率越高, 表示災難復原的時候丟失的資料更少
  3. 頻率高, 時間段內備份的的Log file佔的空間會比頻率低要來的少 (因為空間可重用)

參考來源:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/transaction-log-backups-sql-server?view=sql-server-ver15

Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 3

DigitalOcean 1

Django 1

English 3

Excel 5

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

Machine Learning 2

Manufacture 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 4

Python 21

SEO 2

SQL Server 51

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

自我成長 1

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

bart30508 (146)

Feeds

RSS / Atom

Log Backup Frequency 策略 - SQL Server

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.