Return
-
Title
Does Object Level Recovery (OLR) allow a table to be recovered with a different name? -
Description
Does Object Level Recovery (OLR) allow a table to be recovered with a different name? -
Cause
Does Object Level Recovery (OLR) allow a table to be recovered with a different name?
The UI does not have such option.
-
Resolution
If you use the UI, you can't recover with a different name. But if you script it you can change the name for the @DestinationTable.Here is an example:exec master.dbo.xp_objectrecovery@FileName = N'I:\Backup\test.bak',@FileNumber = 1,@ObjectName = N'dbo.Table_1',@DestinationTable = N'[dbo].[new_Table_1]',@DestinationDatabase = N'LS7',@DestinationServer = N'Mysever',@DisableLogProcessing = 1,@BackEnd = N'SqlNativeClient',@IncludeTableObjects = N'indexes, constraints, triggers, foreignKeys, statistics'