Entry tags:
database backup sizes
Note 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.