• If a database consists of mostly binary attachments, do not compress it when backing it up; it will take twice as long and you won't save any space.

    To find out the theoretical fastest backup you can do, backup to nul as follows:

    backup database mydb to disk="nul" with compression;

    It will do an actual backup to the "bit bucket" without doing the writing part to a local disk, SAN, NAS, tape.