Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - Installation Guide

Using the Cloud

LiteSpeed is able to backup to and restore from Microsoft Azure and Amazon S3 Clouds.

Tip: Set the default compression level to 7 for cloud backups. Using a higher compression level has real savings. Reducing the number of bytes sent to the cloud makes for faster backups and restores and reduces Internet bandwidth.

Using Microsoft Azure

You can get started using Microsoft Azure with LiteSpeed by first setting up a Microsoft Azure account and then registering your account with LiteSpeed.

Setting up Your Microsoft Azure Account

The first step in using Microsoft Azure with LiteSpeed is to create your own account.

To create a Microsoft Azure account

  1. Log in with your existing Microsoft credentials at: https://azure.microsoft.com/en-us/free/ to setup your initial free Microsoft Azure account.

  2. Click Sign up for a free trial.

  3. Complete the Microsoft Azure information page and click Sign up. The Welcome to Microsoft Azure web page is displayed.

  4. Click Start managing my service.

Registering Your Microsoft Azure Account with LiteSpeed

After setting up your Microsoft Azure account, register your account with LiteSpeed before running LiteSpeed backups and restores.

To register a Microsoft Azure account with LiteSpeed

  1. Click .
  2. Click Cloud Accounts.
  3. Click Add.
  4. Select Cloud vendor Azure Blob from the drop-down list.
  5. Enter a display name for this account.
  6. Enter the Storage Account name.
  7. Enter the Access key.
  8. Select Storage type Block Blobs or Page Blobs from the drop-down list.
  9. Enter the Container name or select an existing name from the drop-down list.
  10. Click to deselect or select SSL security.
  11. Click to select or deselect Government account.
  12. Click to deselect or select Automatic Striping. The automatic striping options for block blobs are: auto, 10, 25, 50, 100, and 190 GB. The automatic striping options for page blobs are: auto, 10, 25, 50, 100, 250, 500, and 995 GB.
  13. Click Test Connection to verify that all entered information is working. When successful, the Cloud Accounts screen is displayed with your new account listed.
  14. Click OK to save your entries. Your Microsoft Azure account is now registered with LiteSpeed.

Running LiteSpeed Backups to Microsoft Azure

After first setting up your Microsoft Azure account, and registering your Cloud account with LiteSpeed, you now can run backups to Microsoft Azure using the LiteSpeed Backup Wizard.

To run LiteSpeed backups to Microsoft Azure

Tip: There are three ways to back up to the Microsoft Azure: Backup Wizard, Maintenance Plans, or Backup Templates.

  1. Run the LiteSpeed Backup wizard and make your appropriate selections.
  2. Select Cloud from the destination list and complete the Backup Destination page.

  3. Select the Microsoft Azure account that you created from the Accounts list.

  4. Conclude making the Backup wizard selections and finish by executing the backup.

    Tip: You can review the LiteSpeed cloud backup scripts at the last wizard step before executing the Cloud backup. You can also view an example cloud backup database script here (scroll to the bottom of the page).

Running LiteSpeed Restores from Microsoft Azure

After first setting up your Microsoft Azure account, registering your Cloud account with LiteSpeed, and running backups to Microsoft Azure, you now can run restores from Microsoft Azure using the LiteSpeed Restore Wizard.

To run LiteSpeed restores from Microsoft Azure

  1. Run the LiteSpeed Restore Wizard and make your appropriate selections.
  2. Select Cloud from the Backup Source page and select the Database from which to restore.
  3. Conclude making the Restore wizard selections and finish by executing the restore.

    Tip: You can review the LiteSpeed Cloud restore script at the last wizard step before executing the Cloud restore. You can also view an example Cloud restore database script here (scroll to the bottom of the page).

Using Amazon S3

You can get started using the Amazon S3 with LiteSpeed by first setting up your Amazon S3 account and then registering your Cloud account with LiteSpeed.

Note: LiteSpeed contains all the necessary software and components necessary for using the Amazon S3 and running LiteSpeed backups and restores.

Setting up an Amazon S3 Account

The first step in using the Amazon S3 with LiteSpeed is to create your own Cloud account.

Note: Amazon changes their Cloud account Web UI on a regular basis. Therefore the actual icons, tabs, and selection buttons might be different than what is indicated in the procedures below.

To create an Amazon S3 account

  1. Setup your Amazon account by registering on: http://aws.amazon.com.

  2. Click the IAM icon on the Cloud administration console to create a Cloud user.

  3. The User Access Key IDs and Secret Access Keys are automatically generated.

  4. Write down and save the Access Key IDs and Secret Access Keys. You will use these values later in the LiteSpeed Cloud account registration.

  5. Select the Permissions tab in the Cloud admin console and assign user Administrator Access permissions.

  6. Use the Cloud admin console to create a Bucket Name and Region. This is the location where your backup files will be stored.

  7. Write down and save the Bucket Name and Region. You will use these values later in the LiteSpeed Cloud account registration.

  8. Use the following procedure to register your Amazon S3 Cloud account with LiteSpeed.

Registering an Amazon S3 Account with LiteSpeed

After setting up your Amazon S3 account, then register your Cloud account with LiteSpeed before attempting LiteSpeed backups and restores.

Tip: Make sure to select Cloud Vendor = Amazon S3. Refer to Cloud Account Settings.

To register an Amazon S3 account with LiteSpeed

  1. Click .
  2. Click Cloud Accounts.

  3. Click Add.
  4. Select Cloud vendor Amazon S3 from the drop-down list.
  5. Enter the display name for this account.
  6. Select the authentication type.

    Select Access and Secret Keys to enter the access key and secret key in LiteSpeed.

    1. Enter the Access key saved in Step 4 from the "To create your Amazon S3 account" procedure above.
    2. Enter the Secret key saved in Step 4 from the "To create your Amazon S3 account" procedure above.

    Select IAM Roles to grant permission to the Amazon S3 resource without specifying the Access and Secret key to LiteSpeed. The IAM Role supplies temporary permissions that LiteSpeed can use to make calls to other Amazon Web Services applications. For information on creating and using IAM roles, refer to the Amazon Web Services documentation.

  7. Enter the Region name saved in Step 7 from the same procedure above.
  8. Enter the Storage Class from the drop-down list. The options are standard, standard-infrequent access, and reduced redundancy storage.
  9. Enter the Bucket name saved in Step 7 from the same procedure above.
  10. Click to deselect or select SSL security.
  11. Click to select Use Server Side Encryption (AES-256).
  12. Click to select GovCloud (US) Region.
  13. Click to deselect or select Automatic Striping. The automatic striping options are: auto, 10,25, 50, 100, 250, 500, 1000, and 1995 GB.
  14. Click Test Connection to verify that all entered information is working. When successful, the Cloud Accounts screen is displayed with your new account listed.
  15. Click OK to save your entries. Your Amazon S3 account is now registered with LiteSpeed.
  16. Use one of the following procedures and run the LiteSpeed Backup or Restore Wizard to save backups to the Amazon S3 Cloud or restore files from the same.

Running LiteSpeed Backups to Amazon S3

After first setting up your Amazon S3 account, and registering your Cloud account with LiteSpeed, you now can run backups to Amazon S3 using the LiteSpeed Backup Wizard.

Tip: There are three ways to back up to the Amazon S3 Cloud: Backup Wizard, Maintenance Plans, or Backup Templates.

Caution: The Amazon S3 only runs backup to new files. Appending to an existing file is not supported by the Amazon S3 . Existing backups can only be overwritten. The option "Overwrite existing object" is available in the Backup Wizard and MP (Back Up Database task). The option is turned off by default.

To run LiteSpeed backups to Amazon S3

  1. Run the LiteSpeed Backup wizard and make your appropriate selections.
  2. Select Cloud from the destination list and complete the Backup Destination page.

  3. Select the Amazon S3 account that you created from the Accounts list.
  4. Conclude making the Backup wizard selections and finish by executing the backup.

    Tip: You can review the LiteSpeed cloud backup scripts at the last wizard step before executing the Cloud backup. You can also view an example cloud backup database script here (scroll to the bottom of the page).

Running LiteSpeed Restores from Amazon S3

After first setting up your Amazon S3 account, registering your Cloud account with LiteSpeed, and running backups to Amazon S3 , you now can run restores from Amazon S3 using the LiteSpeed Restore Wizard.

To run LiteSpeed restores from Amazon S3

  1. Run the LiteSpeed Restore Wizard and make your appropriate selections.
  2. Select Cloud from the Backup Source page and select the Database from which to restore.
  3. Conclude making the Restore wizard selections and finish by executing the restore.

    Tip: You can review the LiteSpeed Cloud restore script at the last wizard step before executing the Cloud restore. You can also view an example Cloud restore database script here (scroll to the bottom of the page).

 

Related Topics

Related Documents