![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
database backup sizes
Feb. 18th, 2017 02:42 pmNote to Self:
The size of a SQL Server database backup file does not necessarily reflect the size of the restored database; ie. the hard drive space required to restore the backup.
Example:
329 MB backup file, zipped to 29 MB, required 35 GB to restore.
445 MB backup file, zipped to 55 MB, required only 1 GB to restore.
The difference being, that the latter database had the logs cleared before the backup.
The size of a SQL Server database backup file does not necessarily reflect the size of the restored database; ie. the hard drive space required to restore the backup.
Example:
329 MB backup file, zipped to 29 MB, required 35 GB to restore.
445 MB backup file, zipped to 55 MB, required only 1 GB to restore.
The difference being, that the latter database had the logs cleared before the backup.
