-
Title
Object Level Recovery Performance Enhancement - using the parameter 'OLRMAP' -
Description
Beginning in Version 4.6, when a backup is performed using the LiteSpeed extended stored procedures, a list of the database tables may be included in the backup file by selecting "Optimize the Object Level Recovery speed of the backup". This decreases the amount of time Object Recovery requires to perform a restore operation. This feature is optional and may be enabled in the Backup Wizard, in a Maintenance Plan or t-sql script.
-
Cause
Explanation of functionality.
-
Resolution
In the Graphical User Interface (GUI) Backup Wizard, on the Destination Disk screen, there is a checkbox "Optimize the Object Level Recovery speed of the backup". If this checkbox is deselected, LiteSpeed will omit any reference to this feature in the script. If the box is selected, then the parameter is visible in the t-sql script as @OLRMAP = 1.
Any maintenance plans created or converted on previous versions of LiteSpeed will omit any reference to this feature in the t-sql job step script. To inlcude the list of tables into the backup file, in the Job Step of the Maintenance Plan, add the parameter -OPTOLR. For additional information, please see the LiteSpeed Help File and the Product Release Notes for LiteSpeed Version 4.6.Note: In Version 5.0, OLRMAP will be used for xp_backup_database and xp_slssqlmaint (the parameter OLROPT is no longer in use).
The parameter "Optimize the Object Level Recovery speed of the backup". does not appear in the MMC Backup Assistant. -
Additional Information
An error may display when backing up a remote server with an earlier version of LiteSpeed: "Invalid parameter @OLRMAP supplied Backup failed for database 'database_name'." This is due to the versions of LiteSpeed earlier than 4.6 not utilizing the OLRMAP/OLROPT feature.
An error may display when backing up, using a maintenance plan:
SLS Error: XML returned from Engine was invalid. : Error Msg: (0)
Msg 60200, Level 19, State 1, Line 0
File number '0' is not within the valid range.
Use xp_restore_headeronly for valid file numbers.
WORKAROUND: Remove the @OLRMAP or -OLROPT parameter from the job script, or in the Maintenance Plan GUI, uncheck the 'Optimize the Object Level Recovery Speed of the Backup.'