LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Introduction LiteSpeed Security Features LiteSpeed for SQL Server and FISMA Compliance Customer Measures

Using the Amazon S3 Cloud

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

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

Setting up Your Amazon S3 Cloud Account

The first step in using the Amazon S3 Cloud 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 your Amazon S3 Cloud account

Setup your Amazon account by registering on: http://aws.amazon.com.
Click the IAM icon on the Cloud administration console to create a Cloud user.
The User Access Key IDs and Secret Access Keys are automatically generated.
Write down and save the Access Key IDs and Secret Access Keys. You will use these values later in the LiteSpeed Cloud account registration.
Select the Permissions tab in the Cloud admin console and assign user Administrator Access permissions.
Use the Cloud admin console to create a Bucket Name and Region. This is the location where your backup files will be stored.
Write down and save the Bucket Name and Region. You will use these values later in the LiteSpeed Cloud account registration.
Use the following procedure to register your Amazon S3 Cloud account with LiteSpeed.

Registering Your Amazon S3 Cloud Account with LiteSpeed

After setting up your Amazon S3 Cloud 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 your Amazon S3 Cloud account with LiteSpeed

Use the LiteSpeed Application Menu and select Cloud Accounts.
Select the Add icon. The Add cloud account window opens.
Enter the Access key and Secret key saved in Step 4 from the "To create your Amazon S3 Cloud account" procedure above.
Enter the Region and Bucket names saved in Step 7 from the same procedure above.
Click OK to save your entries. Your Amazon S3 Cloud account has now been registered with LiteSpeed.
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 the Amazon S3 Cloud

After first setting up your Amazon S3 Cloud account, and registering your Cloud account with LiteSpeed, you now can run backups to the Amazon S3 Cloud 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 Cloud only runs backup to new files. Appending to an existing file is not supported by the Amazon S3 Cloud. 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 the Amazon S3 Cloud

Run the LiteSpeed Backup wizard and make your appropriate selections.
Select Cloud from the destination list and complete the Backup Destination page.
Select the Amazon S3 Cloud account that you created from the Accounts list.
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 Amazon S3 Cloud

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

To run LiteSpeed restores from the Amazon S3 Cloud

Run the LiteSpeed Restore Wizard and make your appropriate selections.
Select Cloud from the Backup Source page and select the Database from which to restore.
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).

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem