LiteSpeed for SQL Server 8.9.8 - Security and Compliance Guide

Displays information about the backup volume savings, successful jobs, and failed jobs.

Under Database Properties, see the last backup date.

You can view information about different dates by changing the Period field or select the dates from a calendar.

Lists all of the server instance's databases with their state, recovery model, device, backup destination and last backup date. Print this table or export to Excel.

You can right click on any instance and select backup, multi-database backup, restore, automated restore, backup analyzer, display backup/restore jobs, assign categories (available in some cases), refresh, properties, and activity.

Displays all activity for the selected parameters, including activity type and status, duration, compression ratio, backup throughput (uncompressed backup size to backup duration ratio), Windows domain or SQL Server account that was used to initiate the backup or restore operation, and more.

You can change the parameters in the following fields:

• Period — Select the time span, or select dates from a calendar. The options are all, last hour, last 4 hours, last 8 hours, last 24 hours, last 48 hours, last 72 hours, last week, last 2 weeks, and last month.

• Report type — Select the type of activity to display. Select as a group: backup, restore, verify, and check database. Individually select: backup, restore, verify, check database, smart cleanup, maintenance plans, DTS packages, LiteSpeed jobs, log shipping plans, shrink database, update statistics, rebuild index, and reorganize index. Select Restore by Source to view restore and verify activity with restore destination for the selected instance/database.

• Source — Select the type of backups to display, such as all, LiteSpeed or native SQL Server backups.

• Status — View total instance status including all, success, warning, failure, and in progress.

• Replica - Select Availability Group Replica to display activities. (Available in case of Availability Group database replica selected in Server tree and Central repopository).

You can right click on any instance and select: view in timeline, view details, and re-execute backup.

Tips:

• To re-execute any successful or failed (and fast compression) backup, right-click the activity and select Re-execute Backup... You can edit the script if needed and run it immediately as a SQL Agent job or run it in the background. Note that the Re-execute Backup... menu item is only visible for LiteSpeed backups, and is enabled only for backups that were executed by using t-sql. If the LiteSpeed backup was executed using the command-line then the menu is disabled. Job Name?Schedule?New Activity displayed?Job should include information about activity ID, should be deleted on success;Jobs tab does not show this job?
• To verify the backup, right-click the successful backup activity and select Verify Backup... You can edit the script if needed and run it immediately as a SQL Agent job or run it in the background. Note that the Verify Backup... menu item is only visible for LiteSpeed backups (Full, Diff, Log), and is enabled only for backups that were executed by using t-sql. If the LiteSpeed backup was executed using the command-line then the menu is disabled. Verify Backup is supported for Disk, Cloud and TSM Backup/Archive backups.
• To view information about the native SQL Server backups and restores in the LiteSpeed UI Console, run the Instance Configuration wizard from the start menu and configure the local repository to be updated via a SQL Server job. For more information, see Configure Server Instances.
• To view information about backups performed on all availability group replicas select any database replica of the availability group at the Backup ManagerServer tree.

If you selected a database or server instance in the navigation pane, the tab also displays a timeline of activity. The timeline displays backups and restores from the past and those scheduled to occur in the future.

You can hover over an item for additional information about it. Right-click anywhere in the timeline to navigate to a date, change the time scale, or rotate the name of the databases.

Displays the LiteSpeed Backup templates stored in the central repository. For more information, see Create Backup Templates.

In the Backup Templates tab, you can create, edit, clone, import, export and deploy templates, view the template contents, deployment details and modification history.

NOTES:

• The Backup Templates tab is only available, if the central repository is configured and selected for use. For more information, see About Collecting Statistics in Repositories. To edit, deploy or remove a template when the central repository is not used, click beside Backup Templates on the toolbar and select the appropriate option.
• The template deployment history is not exported when you export a template.

Displays the reports area.

Compliance report. Displays status of databases at the selected SQL Server instance or group,

You can change the parameters in the following fields:

• Period — select the time span, or select dates from a calendar. The options are all time, last hour, last 4 hours, last 8 hours, last 24 hours, last 48 hours, last 72 hours, last week, last 2 weeks, and last month.

• Status — View total database status including all, green, yellow, and red. Database status can be set at General Options in Show database status area.

Note: The Reports tab is only available, if the central repository is configured and selected for use. For more information, see About Collecting Statistics in Repositories.

Displays backup directories and current backup files. You can restore the backup file or begin object level recovery from the files listed in the tab. You can also add directories, delete directories, or set a default directory. NOTE: Backup directory also can be added from the Backup location browse dialogs. Make sure that prefered SQL Server is selected before adding the new backup directory location through the Backup location browse dialog

After expending a directory and making a backup visible, you can right click on the backup and select restore, view content, convert to double click restore backup, and convert to native backup.

Lists all scheduled jobs. You can select different job types in the Jobs filter field.

Right click a job to select the options: change schedule, start, stop, enable jobs, disable jobs, delete, and view in job manager.

Lists the instances in the server group with their display name, authentication method, SQL Server version, LiteSpeed version, and number of databases.

Lists all backups with their date and destination, including native SQL Server backups performed through LiteSpeed. The list also includes backups that have been replaced. You can view information about different dates by changing the Period field or select the dates from a calendar.

Tips:

• To view information about backups performed on all availability group replicas select any database replica of the availability group at the Backup ManagerServer tree.
• Instance Name column shows in case of availability group replica has been selected in Server tree.