-
Title
Object Level Recovery Fails with Errors: "Error # 50000 Failed to create table" or "Unable to loc -
Description
Object level recovery fails with one of the following errors:
"Error # 50000 Failed to create table [Archive]..[WorkPapers_temp3]
Line 2: Incorrect syntax near 'NOT'.
CREATE TABLE [Archive]..[Tablename_temp3]"
OR
"Server: Msg 50000, Level 19, State 1, Line 1
Unable to locate Page 0x0001:0x00000035 in backup file."
OR
"Server: Msg 50000, Level 19, State 1, Line 1
Unable to locate Page 0x0001:0x00000018 in backup file.
No rows found for table dbo.DIM_NDG in backup file." -
Cause
LSM file may be incomplete or corrupt.
-
Resolution
The LSM is the backup map file that contains a list of objects that are in the database backup file. The purpose of the LSM file is to improve performance on the Object Recovery Level. If the .LSM file is corrupted, the Object Recovery Level process may hang or error prior to completion.
WORKAROUND:
Delete the current .LSM file and allow LiteSpeed to recreate a new file upon running Object Recovery Level. A new LSM file will be created only if one does not exist. The .lsm file is created in the same directory as the backup file and is named similarly to: Northwind_db_200607101519.BAK.1.lsm
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. -
Additional Information
The best way to regenerate the LSM is to execute an OLR View Contents operation from the command-line on the machine where the backup file is located, because this isolates the operation.
Rename the old LSM before regenerating it and compare the file sizes (The length of the original file compared to the length of the newly generated one).
OLR View Contents:
Example: To list the objects in the ‘Northwind’ database in the backup filec:\temp\northwind.bak:
C:\Program Files\Imceda\LiteSpeed\SQL Server\Engine>olr -V -Fc:\temp\northwind.bak