LiteSpeed for SQL Server 8.9.5 - Configure Log Shipping Guide

Using the Cloud

LiteSpeed is able to:

• backup to the cloud.
• restore databases and specific objects from the cloud.
• read transaction logs from the cloud.

You can get started using the cloud with LiteSpeed by first setting up your account with the cloud vendor and then registering that account with LiteSpeed.

Note:LiteSpeed contains all the necessary software and components necessary for running LiteSpeed backups and restores to / from the following cloud vendors.

Setting up a cloud account with the cloud vendor

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

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.

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.

Required minimum permissions: "s3:GetBucketLocation", "s3:PutObject", "s3:Get*", "s3:DeleteObject" ("s3:DeleteObject" is optional and not needed if they do not need to delete backups or use the LiteSpeed parameter “init=1.”)

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.

To create a Google Cloud Storage account

LiteSpeed uses Google Storage service accounts access Google Storage. More information about Google storage service accounts can be found here: https://cloud.google.com/compute/docs/access/service-accounts

To create a S3 Compatible Storage account

Please refer to the storage documentation. LiteSpeed uses Amazon S3 API SDK to connect S3 compatible storages.

Registering the cloud account with LiteSpeed

After setting up your vendor cloud account, then register your cloud account with LiteSpeed before attempting LiteSpeed backups and restores.

To register a cloud account with LiteSpeed

1. Click .

2. Click Cloud Accounts.

3. Click Add.

When the vendor is Amazon S3

1. Select Cloud vendor Amazon S3 from the drop-down list.
2. Enter the display name for this account.

3. 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.

4. Enter the Region name saved in Step 7 from the same procedure above. Note: use Custom item to set VPC custom storage endpoint.
5. Enter the Storage Class from the drop-down list. The options are standard, standard-infrequent access, and reduced redundancy storage.
6. Enter the Bucket name saved in Step 7 from the same procedure above.
7. Click to deselect or select SSL security.
8. Click to select Use Server Side Encryption (AES-256).
9. Select 'Use Amazon S3 Transfer Acceleration Speed' to use Amazon's S3 Transfer Acceleration feature which allows for increased upload speed to S3 storage up to 200% in some cases by using local CloudFront endpoints.
10. Click to select GovCloud (US) Region.
11. Click to deselect or select Automatic Striping. The automatic striping options are: auto, 10,25, 50, 100, 250, 500, 1000, and 1995 GB.

When the vendor is Microsoft Azure

1. Select Cloud vendor Azure Blob from the drop-down list.
2. Enter a display name for this account.
3. Enter the Storage Account name.
4. Enter the Access key.
5. Select Storage type Block Blobs or Page Blobs from the drop-down list.
6. Enter the Container name or select an existing name from the drop-down list.
7. Click to deselect or select SSL security.
8. Click to select or deselect Government account.
9. 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.

When the vendor is Google Cloud Storage

1. Select Cloud vendor Google Storage from the drop-down list.
2. Enter a display name for this account.
3. Enter the Service account ID. This is an e-mail styled account.
4. Enter the private key. This is a very long string.
5. Enter the Project ID.
6. Select the Region.
7. Enter the Storage Class from the drop-down list. The options are Multi-Regional, Regional, Nearline and Coldline.
8. The Storage Class and Region are not used by Google. Leave as is.
9. Enter the Bucket. Google defines rules for buckets naming: https://cloud.google.com/storage/docs/naming.
10. SSL Security is always enabled for Google Cloud Storage.
11. Click to deselect or select Automatic Striping.

When the vendor is S3 Compatible Storage

1. Select Cloud vendor S3 Compatible Storage from the drop-down list.
2. Enter the display name for this account.

3. Select Access and Secret Keys to enter the access key and secret key in LiteSpeed generated in the storage options.

4. Enter the storage Endpoint in the format: serverstoragename:port.(i.e. mystoragename:9021)
5. Enter the Bucket name.
6. Click to deselect or select SSL security.
7. Click to deselect or select Automatic Striping. The automatic striping options are: auto, 10,25, 50, 100, 250, 500, 1000, and 1995 GB.

Test the connection

1. Click Test Connection to verify that all entered information is working. When successful, the Cloud Accounts screen is displayed with your new account listed.
2. Click OK to save your entries. Your cloud account is now registered with LiteSpeed.

3. Use one of the following procedures and run the LiteSpeed Backup or Restore Wizard to save backups to the cloud or restore files from the same.

Running LiteSpeed Backups to the cloud

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

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

To run LiteSpeed backups to the cloud

1. Run the LiteSpeedBackup wizard and make your appropriate selections.

2. Select Cloud from the destination list and complete the Backup Destination page.

3. Select the cloud vendor 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 the cloud

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

To run LiteSpeed restores from the cloud

1. Run the LiteSpeedRestore 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

About the Cloud

Backup wizard

Restore wizard

Cloud backup script

Cloud restore script