database backup compression
Hi, I'm using Backup Manager to backup my DVLS instance (version 2023.3.4.4) and everything work fine, the only problem is that usually database backup are pretty big (around 2GB for each backup) and seems they don't use compression.
I don't know if this is because I'm using MS SQL Express, but it would be great if backup compression (and rotation of compressed backups) would be managed by Backup Manager itself.
In my case for example simply compress those backups with zip saves 90% of the space resulting in backup files barely bigger than 200MB.
Do you think this is possible or maybe it will be implemented in a future release?
Thanks
Tas
All Comments (6)
Hello Tas,
It is important to note that the backup file should be compressed as a .zip file at the end of the backup process. Are you currently only seeing .bak files? If so, please ensure that the identity being used by the Devolutions Scheduler service has the "Modify" permissions in the specified folder.
Additionally, there is an option within the backup manager to "Keep number of backups". If you have already configured this option, the missing modify permissions mentioned earlier could be the reason why the old copies are not being removed.
For further information, please visit https://docs.devolutions.net/server/web-interface/administration/backup/backup-manager/#advanced
Best regards,
Richard Boisvert
Hello,
i like to join this thread.
We also use a MS SQL Express 2019, and the result of the scheduled backup is a .bak file of about 1GB in size
user account running the scheduler has full access on the folder,
backup of the web site is compressed as zip file, but not the database
"keep number of backups" is working, the older files are deleted
Same for me, IIS DocumentRoot backup files are compressed with zip, but database backup files have .bak extension and they are not compressed (if I try to compress them their size change from 2GB to ~200MB for each backup).
I also have no problems with retention, backup older than the retention parameter (Keep number of backups) are automatically deleted.
Hi tas and hoppe,
Currently the only way to zip the database backup is to add a Backup database password. After that your .bak will be zip and the password will be set on that zip file.
The only reason we didn't zip all backup file was to prevent any useless operations while doing the backup for client who didn't what to have there backup zipped and wanted to be able to restore them quickly.
You can add a feature request if you would like to have the option to zip the backup without password.
Benoît Sansregret
Thanks Benoit for the information, I added a password to my database backup and now it's compressed.
For me it's not a problem to have the backup in a password protected zip file, but I'll take your suggestion and make a feature request for this and maybe also other backup features.
Thanks again!
Tas
Happy to help!
Benoît Sansregret