How to use the Object Level Recovery, 'OLR', on Differential backups (4249034)

How to use the Object Level Recovery, OLR, on Differential backups

On version 4.8.4 and later, OLR can be use to extract objects from the differential backups.

WORKAROUND:
Use the following script to accomplish this. Note, youll need both the FULL and DIFFERENTIAL backup in order to use the OLR. Heres the syntax:

--This script will list the objects within the FULL backup file.

exec xp_objectrecovery_viewcontents
@FileName = N<directory and FULL backup filename>,
@FileNumber = 1,
@Type = All

go

-- This script recovers the object

exec master..xp_objectrecovery
@FileName = N<directory and FULL backup filename>,
@FileNumber=1,
@DiffFileName=,directory and DIFFERENTIAL backup filename>,
@DiffFileNumber=1,
@ObjectName=<object to recoever>,
@DestinationServer=<Destination Servername>,
@DestinationDatabase=<Destination database name>,
@DestinationTable=N<Name of destination table>,
@TempDirectory=<temp directory to process OLR>

For more information and a list of the parameters, please refer to LiteSpeed Help. Search for the keywords:

xp_objectrecovery_viewcontents
xp_objectrecovery

Differential files cannot be used for a point in time restore due to a limitation of SQL Server (not a LiteSpeed limitation). In both SQL Server and LiteSpeed, the backup must be a transaction log backup, not a differential backup in order to restore to a point in time.
See:http://msdn.microsoft.com/en-us/library/ms190982.aspx