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
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center