Why does Object Level Recovery require a temp table as a destination for restore? Why can't the original table name be used?
LiteSpeed design cannot restore an item of the same name to a database. Typically, the table would be recovered to a different name, and then the data moved from the temp (new) table to the original table, followed by deleting the recovered or temp table.
This function is available via the Object Level Recovery Wizard, or by script.
Example script:
EXEC xp_objectrecovery
@filename='c:\temp\Northwind.BKP'
, @objectname = 'dbo.Products'
, @destinationdatabase='Northwind'
, @destinationtable='Products_temp'
Note, this function is also available in the later versions of LiteSpeed for use on SQL Server native backup files.
Sample script to restore a table from native:
exec master..xp_objectrecovery ,
@FileName='D:\Backup\2000\Northwind_Native_Full.BKP',
@ObjectName='dbo.Categories',
@DestinationServer='servername\instancename',
@DestinationDatabase='Northwind',
@DestinationTable=N'"dbo.Categories_temp"',
@TempDirectory='D:\Backup\20000
