SQL Server 2008 Enterprise Edition (and very likely the new SQL2008 R2 from Standard Edition release onwards) offer a backup data compression feature. This backup compression feature improves the backup speed significantly. “Out of the box” full backup throughput rates of over 1 GB/sec are typical when databases are being backed up from a DSI Solid State Disk -- but this can be even higher. By using these two simple steps you can expect more than double the backup throughput or as the video will show, peaks of 3.9 GB/sec.

1)  Increase the number of destination files
2)  Specify the following options:
        - BUFFERCOUNT = 2000
        - BLOCKSIZE = 65536 (512 by default)
        - MAXTRANSFERSIZE=524288

To download and view video demonstration, please click here.