How to backup large databases. Recommendation.

If you have to backup large SQL Server database with the help of SqlBak, here you will find some recommendations that can speed up the backup process.

1. Free space on your local drive

If you need to backup large database, first of all, you need to make sure that you have enough free space on your local drive. Even if you store your backups somewhere in the cloud, you still need to have enough free space on your local drive to keep the temporary files.

To specify the temporary files folder go to your SqlBak backup job settings and find “Backup options” menu. Then specify a folder on your local drive at “Temp files folder” box. If your local drive is divided into several partitions we recommend you to use the biggest one.

2. Use 7 zip compression

To reduce a backup file size you can compress backups using 7-zip compression. This option is available on the “Compression” menu,  just select “.7z” from the drop down list at  “Archive format” section. Also, you can speed up the compression procedure at the “More 7-zip compression options” with the help of the following command line option:

-m0=LZMA2 -mmt=on

Once you decided to apply this command you have to remember that it loads CPU higher.

3. Backup one DB, send, repeat

If you backup many databases in one backup job we also recommend you to use “Backup one DB, send, repeat (as opposite to backup all, then send all)” option, which is located at the “Backup options” menu. If you checked that option, then SqlBak will backup each database one by one in the following way:

  • backup
  • compress
  • send on destinations
  • remove it from the temporary folder

SqlBak Backup options

By default this option is unchecked and SqlBak backup and compress all databases first, send on destinations and only then remove them from the temporary folder.

[Total: 1    Average: 5/5]

Leave a Reply

Your email address will not be published. Required fields are marked *