Customer would like to recovery multiple tables (or any object) in a single command using the Object Level Recovery wizard or from the command line.
WORKAROUND:
It can be scripted, see example:
EXEC xp_objectrecovery
@filename='D:\Backup\Northwind\Northwind_db_200610301306.BAK'
, @objectname = 'dbo.Products'
, @destinationdatabase='Northwind'
, @destinationtable='Products_temp5'
go
EXEC xp_objectrecovery
@filename='D:\Backup\Northwind\Northwind_db_200610301306.BAK'
, @objectname = 'dbo.Orders'
, @destinationdatabase='Northwind'
, @destinationtable='Orders_temp6'
go
EXEC xp_objectrecovery
@filename='D:\Backup\Northwind\Northwind_db_200610301306.BAK'
, @objectname = 'dbo.Shippers'
, @destinationdatabase='Northwind'
, @destinationtable='Shippers_temp7'
STATUS:
An enhancement request has been submitted to Development for consideration in future release for LiteSpeed for SQL Server
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy