LiteSpeed for SQL Server 8.9.8 - User Guide

LiteSpeed_SyncJobs_Stats

This stored procedure synchronize LiteSpeed Jobs, Maintenance plans or Log Shipping activity and information from LiteSpeed Local to the Central database. Using the procedure the date and time can be defined from which to which date and time the data will be synchronized from the Jobs, Maintenance plans or Log Shipping

NOTE: Run the LiteSpeed_SyncJobs_Stats procedure against the desired Local database that is installed on the SQL Server from which you want to synchronize data to the Central database.LiteSpeed databases (Local and Central) by default are named LiteSpeedLocal and LiteSpeedCentral.

• NOTE: Custom database—You can use the LiteSpeed Instance Configuration wizard (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration) to choose where to store the repository data if is not set by default names.

This topic covers:

• Syntax

• Arguments

• Examples

Syntax

exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats @startDate = '20210517 04:05'
{ @startDate = 'date time' }

or

exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats @startDate = '20210517 04:05', @endDate = '20210516 04:04'
{ @startDate = 'date time' | ( @endDate = 'date time' )}

Arguments

This stored procedure accepts the following arguments:

Examples

1. Synchronize the following data from the beginning until 08/08/2021 08:00 from the Local to the Central repository:

   • LiteSpeed Jobs, Maintenance plans or Log Shipping activity
   • The data from the desired activity will be synchronized from the Local to the Central repository

   exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats @startDate = '20210808 08:00'
   

2. Synchronize the following data from the 04/04/2020 07:15 until 08/08/2021 08:00 from the Local to the Central repository:

   • LiteSpeed Jobs, Maintenance plans or Log Shipping activity
   • The data from the desired activity will be synchronized from the Local to the Central repository

   exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats
   @startDate = '20210808 08:00',
   @endDate = '20210404 07:15'
   

In a graphical user interface, right-clicking on a server reveals the option Sync Local and Central Activities.

This option opens the Configure LiteSpeed Local and Central Synchronization dialog, where a user selects Server instances and the option to Sync Jobs, Maintenance plans or Log Shipping activity between local and central repositories. The date range for data synchronization can be selected from the calendar view.

Related Topic

LiteSpeed_SyncActivity_Stats

Purge Repository Data

Cloud

About the Cloud

LiteSpeed supports backup and restore directly to and from the following.

Note: Cloud backup and restore is only available with the Enterprise license.

Microsoft Azure Blob

Microsoft Azure Blob storage is a cloud object storage that can be used to store any data, including SQL Server database backups. Information about the Microsoft Azure Blob is available at https://azure.microsoft.com/en-us/services/storage/blobs/

Amazon S3 (Simple Storage Service) cloud storage

Amazon S3 provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the Web. Information about the Amazon S3 is available at: http://docs.aws.amazon.com/AmazonS3/latest/dev/Introduction.html.

Google Cloud Storage

Google Cloud Storage is unified object storage for developers and enterprises, from live data serving to data analytics/ML to data archiving. LiteSpeed supports Multi-Regional, Regional, Nearline and Coldline storage types. More information on Google Cloud Storage is available at https://cloud.google.com/storage.

S3 Compatible Storage

S3 Compatible Storage provides access to S3 compatible storage by using Amazon S3 API SDK. Please refer to the storage documentation for compatibility between the storage and Amazon S3 API. Information about the Amazon S3 is available at:http://docs.aws.amazon.com/AmazonS3/latest/dev/Introduction.html.

Related Topics

Using the Cloud

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.

Note:A Double Click Restore can only be created for a disk file and LiteSpeed does not offer the funcitionality to perform backup or restore directly to the cloud for these files.

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