sql 备份 文件大小_预测SQL备份大小

sql 备份 文件大小

This article will cover the process of analyzing and predicting/forecasting the size of a SQL backup as a means to better handle/manage retention of backups.

本文将介绍分析和预测/预测SQL备份大小的过程，以更好地处理/管理备份保留。

One of the main database management tenets is “Do not lose your data”. According to this; a database administrator incurs huge responsibilities to protect data. Under these circumstances, taking database backups and archiving SQL backup files is a key task for database administrators. In data protection strategy, taking database backups and archiving backup file processes play the leading role. Especially, backup planning is very significant for disaster recovery scenarios because backup file will be used for restore operation after any failure or data corruption. For this reason, every dba must generate recovery strategies for possible disaster scenarios and ensure that these scenarios can be solvable. At the same time, these backup files must be tested for data integrity; thus process provides to evaluate the recovery time and integrity of backup files. In this Backup and Restore (or Recovery) strategies for SQL Server database article you can find all details about backup and restore strategies.

数据库管理的主要原则之一是“不要丢失数据”。 根据这个; 数据库管理员要承担保护数据的巨大责任。 在这种情况下，进行数据库备份和归档SQL备份文件是数据库管理员的一项关键任务。 在数据保护策略中，进行数据库备份和归档备份文件过程起着主导作用。 特别是，备份计划对于灾难恢复方案非常重要，因为备份文件将在发生任何故障或数据损坏后用于还原操作。 因此，每个dba必须为可能的灾难场景生成恢复策略，并确保这些场景可以解决。 同时，必须测试这些备份文件的数据完整性。 因此，该过程可以评估备份文件的恢复时间和完整性。 在此SQL Server数据库的备份和还原（或恢复）策略文章中，您可以找到有关备份和还原策略的所有详细信息。

After this brief introduction about backup and restore operation significance, we need to highlight one more term about backup files life cycle which is backup retention.

在简要介绍了备份和还原操作的重要性之后，我们需要再强调一个有关备份文件生命周期的术语，即备份保留。

什么是SQL备份保留？ (What is SQL backup retention?)

According to the organization requirement, backup files must be retained and ready for use at the end of the expired date. This data protection task is named backup/data retention. The amount of time which elapsed to protect to data is backup retention time. This time period and number of backup files can be changed by organization retention policies. There are several factors which affect the retention periods but the main factor which affects this period is organization legal requirements. If your SQL Server databases are host on-premise you have to make disk and media capacity planning for backup retention times. But if your SQL Server runs in Azure, you can take advantage of long-term backup retention feature. This feature allows us to retain Azure SQL database backups for more than 10 years. Of course, this feature will be added as a cost to your Azure bills.

根据组织的要求，必须保留备份文件，并在到期日期结束时准备好使用。 此数据保护任务称为备份/数据保留。 保护数据所花费的时间就是备份保留时间。 可以通过组织保留策略来更改此时间段和备份文件的数量。 有几个因素会影响保留期限，但影响此期限的主要因素是组织法律要求。 如果您SQL Server数据库是本地主机，则必须为备份保留时间制定磁盘和介质容量规划。 但是，如果您SQL Server在Azure中运行，则可以利用