April 2015
Intermediate to advanced
504 pages
11h 41m
English
Performance is often a concern in any medium or large database.
Backup performance is often a delicate issue, because resource usage may need to be limited to within certain boundaries. There may also be a restriction on the maximum runtime for the backup, for example, if the backup runs every Sunday.
Again, restore performance may be more important than backup performance, even if backup is the more obvious concern.
If performance is a concern or is likely to be, then you should read the Planning backups recipe first.
Backup and restore performance can be improved in different ways, depending on the backup type: