LiteSpeed for SQL Server 8.9.8 - Security and Compliance Guide

Table of Contents

Introduction LiteSpeed Security Features LiteSpeed for SQL Server and FISMA Compliance Customer Measures

New in This Release

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. 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 is added in the Backup Template Deployment Wizard in order to mark the servers which don’t match the given criteria set in Backup Template Wizard. After setting a wildcard on the Select Databases step in the Backup Template Wizard, on the Select Instances step in Deployment Wizard the Servers which don’t contain a database with a wildcard expression would be marked 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.

Enhancements

Automatically delete log files older than ‘n’ days option is added under the LiteSpeed Logging window
Disconnect users when restoring full backup option is added under the Backup options step in the Create Log shipping Plan Wizard window
The wildcard validation for the databases is added in the Backup Template Deployment wizard under the Deploy step
The mirror option is added under the Backup options step in the Create Log shipping Plan Wizard
Synchronize local and central activities option is added in the context menu of SQL Server tree in Backup Manager which to delete duplicate data in local and central repositories
Reversing Log Shipping plan roles procedures without performing a full backup option is added under the Backup options step in the Log Shipping Plan

Closed LiteSpeed 8.9.7