The first variable that is shown on the x-axis is the argument of the descriptive, and the second variable shown on the y-axis is the predicted output of the dependent variable. Simple linear regression method can be first potential candidate because when we look at the definition of simple linear regression Simple linear regression is a statistical method that specifies the relationship between two quantitative data’s. We can handle this issue with some statistics calculation methodologies. If your concern is about storage or disk requirement for long terms (week, month, quarter, etc.) we need more sophisticated calculation methods. According to these details, we can calculate the backup size with the following formula īackup Size (MB) = ((Reserved (KB) – Unused (KB))/1024)/1024įor our scenario, the estimation of backup size is approximately equal to ((543328 (KB)) – (21512 (KB))/1024)/1024 = 509 (MB).This calculation method is very useful for calculating next backup size but the disadvantage of this calculation method is that it does not give any idea about the backup file growing trend or acceleration for a particular term. Unused column defines a specific part of reserved data but it is not yet used by database. Reserved column defines the database size which consists of data and log files. The reserved column value approximately gives information about size of uncompressed backup size. When we want to estimate the next backup size we can use the following stored procedure which gives some information about the backup size. Of course, this feature will be added as a cost to your Azure bills. This feature allows us to retain Azure SQL database backups for more than 10 years. But if your SQL Server runs in Azure, you can take advantage of long-term backup retention feature. If your SQL Server databases are host on-premise you have to make disk and media capacity planning for backup retention times. There are several factors which affect the retention periods but the main factor which affects this period is organization legal requirements. This time period and number of backup files can be changed by organization retention policies. The amount of time which elapsed to protect to data is backup retention time. This data protection task is named backup/data retention. What is SQL backup retention?Īccording to the organization requirement, backup files must be retained and ready for use at the end of the expired date. In this Backup and Restore (or Recovery) strategies for SQL Server database article you can find all details about backup and restore strategies.Īfter 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. 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. For this reason, every dba must generate recovery strategies for possible disaster scenarios and ensure that these scenarios can be solvable. 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. In data protection strategy, taking database backups and archiving backup file processes play the leading role. Under these circumstances, taking database backups and archiving SQL backup files is a key task for database administrators. According to this a database administrator incurs huge responsibilities to protect data. One of the main database management tenets is “Do not lose your data”. 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.
0 kommentar(er)
