LiteSpeed for SQL Server 8.9.8 - Security and Compliance Guide

New features

New features in LiteSpeed 8.9.8:

• An automatic process that can delete the logs files every n days is added under Support menu item LiteSpeed Logging when the user right-clicks on a server in the server explorer tree. To enable Automatically delete log files older than the user needs to check one of the Enable checkboxes and then check the Automatically delete log files older than box and type into a numeric box number the desired number of days. Since LiteSpeed Logging option can create many log files, log files will be deleted after that number of days from the location of log files from Log file path set in the same form to free up the drive
• The argument @Disconnect Users is added when specifying backup options in Create LiteSpeed Log Shipping Plan Wizard to disconnect users while performing restore to the subscribers. This option can be checked only if Perform full backup and then restore to initialize subscriber(s) is also checked. If Perform full backup and then restore to initialize subscriber(s) is unchecked this option would be disabled and unchecked. If the option Disconnect users when restoring full backup was checked in the backup options tab, the script that is generated in the final step of the wizard will contain @DisconnectUsers = 1 for the xp_restore_database procedure
• The wildcard validation for the databases in the Backup Template Deployment wizard is added under the Deploy step in order to mark the servers which don’t match the given criteria. After setting a wildcard on the Select Databases step in the Backup Template Wizard, on the Select Instances step the Servers which don’t contain a database with a wildcard expression would turn red.
• The mirror option under the Backup options in the Log shipping is added in order to copy the backup file from the original location to the defined mirror location. After selecting the checkbox and entering the mirror path by typing the path or browsing from the Backup Location dialog, clicking Next would validate the path. In the Job Manager results can be: Success if both backup and mirroring operations succeed, Warning if the mirroring operation fails, or Error if both backup and mirroring operations fail.
• Sync local and central activities is added in order to run synchronization between local and central repositories for one or more servers. Configure LiteSpeed local and central synchronization is opened after right-clicking on a specific server or all servers in Backup Manager only and selecting an option Sync local and central activities. Server instances, procedures, type of activity to be sync and period can be chosen. There is an option to preview the script by selecting the View T-SQL option. After the run is deployed popup window will be shown, showing the Executing action and Execution succeeded message. During the synchronization process, LiteSpeed Console is not accessible until the action is complete.
• Reversing Log Shipping Plan Roles Procedures are enabled in order to create a functioning log shipping plan without creating a full backup. LiteSpeed will perform steps that ensure the synchronicity between the two databases during the change role process by killing connections, disabling Log Shipping jobs, and creating a final tlog backup and restore before switching roles. A new feature will only work if Change Roles is being used to change roles of databases that are already involved in the same Log Shipping Plan and the two databases are synchronous to begin with. This feature can be used during the Change Role Wizard by first unchecking the Perform full backup and then restore to initialize subscriber(s) checkbox, and then checking the Continue shipping logs without full backup checkbox. The latter checkbox will be added as part of this feature and will not be visible unless the former checkbox is unchecked. Clicking the latter checkbox will produce a warning message box. The original feature is completely preserved.

For more details please visit the following links:

• Enhancements
• Resolved issues