Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.7 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Configure LiteSpeed Options

LiteSpeed requires the following privileges and grants:

Account Requirement

User account that performs the LiteSpeed installation

 Windows administrator rights and DBA privileges required to
  • Install stored procedures and extended stored procedures
  • Create databases, tables, and indexes
  • Insert, update, and delete to/from the MSDB, LiteSpeedLocal and LiteSpeedCentral databases
User account that runs the LiteSpeed UI Console

Power User privileges (or some equivalent).

NOTE: When executing a Double Click Restore, Windows Vista, Windows Server 2008, and higher require that the Windows user account is an administrator.

SQL Server service account

Sysadmin server role privileges required to

  • Push stats to local repository
  • Back up or restore using extended stored procedures
  • Execute a scheduled job
  • Start a job manually

TIP: The SQL service account needs at least read\write access to the following directory and all its contents:
C:\ProgramData\Quest Software\LiteSpeed\SQL Server\

NOTE: SQL Server Configuration Manager should always be used when changing SQL Server service accounts.

SQL Agent service account (or a proxy account)

Windows or SQL Server accounts specified during instance configuration (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration)

For more information, see Configure Server Instances.

If you select SQL Server authentication, the SQL Server account must have sysadmin server role privileges, while the Activity Manager service account must have the Log on as a service permission.

If you select the Windows authentication method for both the local and central repository, then the Activity Manager service account specified on the Service Account page must have the sysadmin privileges and the Log on as a service permission.

NOTE: If the central repository is located on another server, the LiteSpeed Activity Manager service account must have domain rights for two-way communication between the local and central repositories.

Windows or SQL Server account (Application Button | Repository Registration...)

For more information, see About Collecting Statistics in Repositories.

Db_owner of the central repository (required to retrieve data from the central repository)

Windows or SQL Server account (Application Button | SQL Server Registration...)

Sysadmin server role privileges required to

  • Connect to SQL Server and retrieve SQL Server properties
  • Back up or restore
  • Execute procedures, retrieve MSDB history
  • Access repositories

TSM with LiteSpeed

If using TSM, its recommended that the following line be added to the dsm.opt file used by LiteSpeed.

errorlogname "C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs\dsierror.log"

 

General Options

Use the options pages to customize settings in LiteSpeed. There is a General options page to select basic settings, and a separate options page for each main feature in LiteSpeed.

To set General options

  1. Click the Application Button and select Options (Keyboard: ALT+F+O).

  2. Review the following for additional information:

    Use this option...

    To...

    Default

    Select central repository

    Select a central repository to view statistics in the LiteSpeed UI Console. You must register the repository before you can select it. For more information, see Register Central Repositories.

    Not Selected

    Display properties in dockable window

    View properties about the item selected in the navigation pane in a dockable window.

    Cleared

    Show confirmation message View confirmation message when exiting the LiteSpeed UI Console or wizards.

    Cleared

    Show background task complete notification View background task complete notification messages.

    Cleared

    Log the LiteSpeed UI Console activity

    Select a logging level to define what events to log for the console. You can find the log events in the Application Event Log.

    Errors only

    Show database status

    View if a database has been backed up recently using LiteSpeed

    The instance tree view displays databases icons of the following colors:

    • GREEN—If the latest database backup was successfully created within the number of days specified for GREEN.
    • YELLOW—If the latest database backup was successfully created within the number of days specified for YELLOW and NOT in the number of days specified for GREEN.
    • RED—If the latest database backup was NOT successfully created within the number of days specified for YELLOW.

    NOTE: Database status can only be displayed for LiteSpeed backups and if the local repository is configured.

    		 Cleared

 

Backup Manager Options

To set Backup Manager options

  1. Click the Application Button and select Options (Keyboard: ALT+F+O).

  2. Select the Backup Manager tab. Review the following for additional information:

    Use this option...

    To...

    Default

    View content timeout

    Enter the connection timeout for when you view the backup file content.

    30 seconds

    TSM device retry time

    Select the amount of time to wait for the device to become available, or not to retry.

    No retries

    Show TimeLine on LiteSpeed Activity tab

    View database backups in a timeline at the server and database level.

    		 Selected
    Use UTC time for LiteSpeed Activity If selected LiteSpeed Activity will use UTC time to display and sort activities on the list. Useful in case of several Sql Server instances in different time zones. If not selected the local Sql Server instance time used. Not selected
    Ask for confirmation when making changes to the Central View

    Display a confirmation message before you are able to edit central repository instances.

    		 Selected
    Ask to import instances when switching from Local to Central View.

    Display a confirmation message about importing registered SQL Server instances when switching from the Local to Central View.

    		 Selected
    Automatic refresh Overview every.

    Refresh the Overview and LiteSpeed Activity screens a configurable amount in increments from 1 to 30 minutes.

    		 Not selected
    Specify proxy settings if needed to set up cloud storage connection.

    Specify proxy settings for the LiteSpeed console. Select the Proxy Settings link and enter the following.

    • Use proxy - Click to enable proxy use.
    • Address - Proxy server address.
    • Port - Proxy server port (default is 80).
    • Username - Proxy server user credential.
    • Password - Proxy server password credential.
    		Not selected

 

Log Shipping Options

To set Log Shipping options

  1. Click the Application Button and select Options (Keyboard: ALT+F+O).

  2. Select the Log Shipping tab. Review the following for additional information:

    Use this option...

    To...

    Default

    Read subscriber information

    View subscriber information on the Monitoring tab.

    Selected

    Display detailed status information on the Monitoring tab

    Show the details panel on the Monitoring tab. The details panel displays tips if there is something wrong with the log shipping plan.

    Selected

    Load log shipping plan statuses...

    View current statuses of all log shipping plans when connecting to the server instance and when refreshing the Log shipping plans tab at the instance level.

    If this option is off, plan status is only loaded when you double-click a plan.

    		 Cleared

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating