-
Title
Why does LiteSpeed create lsm*.tmp files in the temporary directory? -
Description
What is the origin of the lsm###.tmp files in the SQL Server's Service account temp directory? The files are being created in the C:Documents and Settings<sql service account>Local SettingsTemp directory.
-
Cause
These files are created when 'Optimize the speed of the Object Level Recovery' is checked in the LiteSpeed Backup Wizard or Maintnenance Plan.
-
Resolution
If 'Optimize the speed of the Object Level Recovery' is selected for a LiteSpeed backup (t-sql parameter is OLRMAP=1 and the command prompt parameter is --OLRMap ) then a LiteSpeed Map file is created as a temporary file, named lsm*.tmp. The files are created, written to the header of the LiteSpeed backup file and deleted once the LiteSpeed command has completed.
-
Additional Information
Executing xp_objectrecovery_viewcontents also creates permanent *.lsm files in the same folder as the backup file.
Object Level Recovery allows the restore of specific objects from a native or LiteSpeed full database backup file. Before you can recover objects , you must read the backup file to create an index of restorable objects . You can restore tables, schemas, or execute a select statement to restore to a different database. Object level recovery is only available with the Enterprise license.
Beginning in LiteSpeed Version 5.0, you cannot restore objects in encrypted backup files.