Restoring a table using the OBJECT LEVEL with Full and Differential backups (4326956)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Restoring a table using the OBJECT LEVEL with Full and Differential backups
Description

Example restoring a table using the OBJECT LEVEL with Full and Differential backups
Resolution

Here's the steps using version 6.5:
If using the GUI, you just need to add all the Full, and Differential Backup files in the 'Select Backup Source Files' window.

Here's an example if you use a script:

This is the script for viewcontent

exec xp_objectrecovery_viewcontents
@FileName = N'C:\Backups\LiteSpeedDemo.litespeed.f3.bkp', ---FULL BACKUP
@FileNumber = 1,
@Type = 'All',
@DiffFileName = N'C:\Backups\LiteSpeedDemo.litespeed.f3.d0.bkp', --DIFFERNETIAL BACKUP
@DiffFileNumber = 1

This is the restore script

exec xp_objectrecovery
@FileName = N'C:\Backups\LiteSpeedDemo.litespeed.f3.bkp', --FULL BACKUP
@FileNumber = 1,
@DiffFileName = N'C:\Backups\LiteSpeedDemo.litespeed.f3.d0.bkp', --DIFFERENTIAL BACKUP
@DiffFileNumber = 1,
@ObjectName = N'dbo.TestForDemo',
@DestinationTable = N'dbo.TestForDemo',
@DestinationDatabase = N'apostrophes''test',
@DestinationServer = N'ALV106543\SQL2005'

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title