How to use LiteSpeed's "Object Level Recovery" to restore a table to particular filegroup? (4353614)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to use LiteSpeed's "Object Level Recovery" to restore a table to particular filegroup?
Description

Is it possible the use "Object Level Recovery" to restore table to particular filegroup from a database backup file?
Resolution

In order to restore table’s data to a different FILEGROUP, use the @OnFileGroup parameter, and for the table’s BLOB data use the @TextImageOnFileGroup parameter.

Example:
EXEC xp_ObjectRecovery
@FileName='E:\SharePoint.bak'
, @ObjectName='dbo.Docs'
, @DestinationDatabase='tempdb'
, @OnFileGroup='SECONDARY'
, @TextImageOnFileGroup='TERTIARY'
Defect ID

ST44044
Additional Information

In versions 4.6 thru 5.0, this feature is not working. The defect is described as: The table is restored to the primary filegroup even though the second or third filegroup was specified.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title