How to restore multiple tables or objects using OLR? The feature is not available when using the Graphical User Interface (GUI).
N/A
RESOLUTION: None
WORKAROUND:
Run the following script from Query Analyzer. Note that several tables have been selected from one backup file.
EXEC xp_objectrecovery
@filename='D:\Backup\Northwind\Northwind_db_201010301306.BAK'
, @objectname = 'dbo.Products'
, @destinationdatabase='Northwind'
, @destinationtable='Products_temp'
go
EXEC xp_objectrecovery
@filename='D:\Backup\Northwind\Northwind_db_201010301306.BAK'
, @objectname = 'dbo.Orders'
, @destinationdatabase='Northwind'
, @destinationtable='Orders_temp'
go
EXEC xp_objectrecovery
@filename='D:\Backup\Northwind\Northwind_db_201010301306.BAK'
, @objectname = 'dbo.Shippers'
, @destinationdatabase='Northwind'
, @destinationtable='Shippers_temp'
If a specific temp directory is to be specified, add the parameter: @tempdirectory = 'recovery_temp_dir'
