When running the Object Level Recovery process, files with an '.lsm' extension are being created in the same backup location. What are these LSM files and can they be deleted?
An LSM file is a LiteSpeed Map file, that is used to perform Object Level Recovery.
The LSM file can be deleted; however, the LSM file will be recreated during the object recovery operation, which will slow down the recovery.
Note: To produce a listing of all objects found within the backup file, from the command prompt, navigate to the folder containing the OR.exe The default location is:C:\Program Files\Imceda\LiteSpeed\SQL Server\Engine. Run the command >OR.exe -V -t TraceLog.txt -m "ORMap:All" -F D:\Backup\Northwind.bak
The parameters -t -m are case sensitive.
In later versions of LiteSpeed, the parameter 'OLRMAP' may be added to the backup script and the ldm file is created internally, with the backup file. Thus saving time, if an Object Recovery was required later. This does add a minor amount of overhead to the backup process.
