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.
Options
| Option | Required | Description |
|---|---|---|
| ratemb | Yes | The maximum rate in MB/s. This can be used to limit both backups and restores. |
Example
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)"
| About |
| Download |
| Project Page |
| Documentation |
| Ask Questions |
| Blog |