LiteSpeed for SQL Server 8.9.1 - Security and Compliance Guide

Cloud Automatic Striping

Striping is splitting one backup file into multiple files. The advantage of striping is that it provides higher upload performance when backing up to the Cloud and overcomes some Cloud limitations (e.g. maximum object size on Azure Block Blob storage is 4.75TB). Striping provides a significant performance benefit and time saving when backing up large database files. For example, striping three blocks of one database file up provides three times the upload bandwidth over backing up one large database file to a single cloud container.

Setting up Cloud Automatic Striping

LiteSpeed provides an automatic striping option for backing up databases. The option can be set to auto which enables LiteSpeed to manage the striped size. Alternately, you can set the striping size in GB. If the database size is larger than the specified stripe size then the file is striped when backed up.

To enable cloud automatic striping

1. Click .
2. Click Cloud Accounts.
3. Click Edit.

4. Click to select Automatic Striping. The automatic striping options:

   • Microsoft Azure blob storage (Block blob): auto, 10, 25, 50, 100, 250, 500, 1000, 2000, 3000, 4000 and 4300 GB.

     Note: Maximum size of block blob supported by Microsoft Azure is 4.77 TB. Stripes allow to override this limit.

   • Microsoft Azure blob storage (Page blob): auto, 10, 25, 50, 100, 250, 500 and 995 GB.

     Note: Maximum size of page blob supported by Microsoft Azure is 1000GB. Stripes allow to override this limit.

   • Amazon S3: auto, 10, 25, 50, 100, 250, 500, 1000 and 1995 GB.

     Note: Maximum size of object supported by Amazon S3 is 5000GB. LiteSpeed is limited by 2000GB. Stripes allow to override this limit.

   • S3 Compatible Storage: auto, 10, 25, 50, 100, 250, 500, 1000 and 1995 GB.

     • Note: Maximum size of object supported by S3 Compatible Storage is 5000GB. LiteSpeed is limited by 2000GB. Stripes allow to override this limit.

   • Google Cloud Storage: auto, 10, 25, 50, 100, 250, 500, 1000 and 1995 GB.

     Note: Maximum size of object supported by Google Cloud Storage is 5 TB. LiteSpeed is limited by 2TB. Stripes allow to override this limit.

      

5. Click Test Connection to verify that all entered information is working. When successful, the Cloud Accounts screen is displayed with your new account listed.
6. Click OK.

Related Topics

About the Cloud

Backup wizard

Restore wizard

Cloud backup script

Cloud restore script