View Log Shipping Activity and History
The LiteSpeed UI Console provides information about native and LiteSpeed log shipping plans in the Log Shipping tabs. Depending on what level of the navigation pane tree you select, you can view the plans for a server, log shipping jobs, and activity history. You can view information about a category, subcategory, server instance, server group, all of your server instances, or a specific log shipping plan by selecting the appropriate level in the navigation pane tree.
NOTE: You need to register all SQL Server instances involved in log shipping in the LiteSpeed UI Console to retrieve log shipping data for them.
| Tab | Level | Description |
|---|---|---|
| Overview | All |
Displays information about the backup volume savings, successful jobs, and failed jobs. You can view information about different dates by changing the Period field or clicking |
| Log Shipping Plans | Server instance |
Displays all log shipping plans for the selected level with their publishing database, number of subscribers, and status. Double-click a plan to navigate to its Monitoring tab. Right-click to view the plan's jobs, properties, or refresh. Tip: To view current status of all log shipping plans when connecting to the server instance and when refreshing the tab, select Tools | Options | Log Shipping and enable the Load log shipping plan statuses... option. |
| History | Server instance and plan |
Activity log: The History tab lists log shipping activity for the selected parameters in a grid. You can change the parameters in the following fields:
Errors: If the activity had errors, double-click the row in the bottom of the pane to view the errors details. Tip: Export the grid to Microsoft Excel or print the grid. |
| Monitoring | Plan |
Monitor shipping progress: The Monitoring tab represents the plan in a diagram with its shipping progress from the publisher to subscribers. The progress lines represent the amount of time until LiteSpeed generates an alert. You can hover over the databases and progress lines for additional information. The Monitoring tab has the following options:
NOTE: If you need to synchronize the publisher and subscriber databases or reinitialize log shipping, right-click the subscriber database and select the appropriate option. For more information, see Troubleshoot Log Shipping. View suggested solutions: If there are any problems with the log shipping plan, LiteSpeed displays the problem and suggested solution in the bottom of the pane. |
to select the dates from a calendar.|
Tip: For panes that have grids, you can sort, group, move, and remove the columns:
|
NOTE: 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.