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.
These files are created when 'Optimize the speed of the Object Level Recovery' is checked in the LiteSpeed Backup Wizard or Maintnenance Plan.
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.
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.