Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9 - Installation Guide

View Backup Manager Activity and History

The LiteSpeed UI Console provides information about your backup processes in the Backup Manager tabs. Depending on what tree level and tab you select, you can view statistics on processes that fail or succeed, the amount of disk space you save, a list of all of the jobs for a server instance or database, and additional information.

Troubleshooting: If you upgraded from a previous version of LiteSpeed, the timeline may not automatically display all of your activity. For more information, see 4.x jobs not displayed. on what could be missing and how to fix it.

You can view the backup activity and history by selecting the Backup Manager Server Tools Ribbon. Information about a category, subcategory, database, server instance, server group, or all of your server instances by selecting the appropriate level in the tree.

Tab Name

Available Level

Description

Overview

All

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.

Databases

Server instance

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.

LiteSpeed Activity

All

 

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

Backup Templates

All

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.
Reports Server group and Server instance

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:

  • Backup not run for — 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.

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

Backup Browser

Server instance

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.

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.

LiteSpeed Jobs

Server instance and Database

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.

Further list, backup template, backup history, and backup analyzer information is provided in the following table.

Tab Name

Available Level

Description

List

Server group

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

Backup History

Database

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.

Backup Analyzer

Database

Analyzes different settings, such as compression level, striping, and backup destinations, to determine which settings have the best compression and duration values. For more information, see Test Optimal Backup Settings.

You can group server instances in the navigation pane tree based on their category or server group. Categories are similar to server groups, but they offer different features. For more information, see Change Server Instance Grouping Methods. 

Tip: For panes that have grids, you can sort, group, move, and remove the columns:

  • To sort and group the records, right-click a column header and select the appropriate options.
  • To sort records against multiple columns, click column headers while holding the SHIFT key. For example, to sort by type and then by name, click the Type column header and then SHIFT+click the Name column header.
  • To add or remove columns, right-click a column header and select Column Chooser. Add a column by dragging it from the list into the column headers. Remove a column by dragging its column header into the list.
  • To move a column, drag the column header to the new location.
  • After you refine the report criteria, you can print the results or export them to Excel. In addition, the tab has a timeline that displays the activity for the selected parameters by their date.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating