SQL Server Compressed Backup


Rate Plugin Reference

The Rate plugin is used for slowing the backup down to prevent the system from being overloaded. It is completely safe to slow the backup with the following caveats:

  • Shrinking files is not allowed during backups. During a backup, SQL Server prevents databases from being shrunk, including automatic shrinking.
  • You cannot add or remove files during backups. SQL Server locks the list of files in the database during the backup.


ratembYesThe maximum rate in MB/s. This can be used to limit both backups and restores.


The example below backs up the data at 2.1 MB/s.

msbp.exe backup "db(database=model)" "rate(ratemb=2.1)" "local(path=c:\model.bak)"