Restore backup to different filegroup

Posted on

Question :

Using Sql Server 2008R2.

I have a backup of a filegroup. Is it possible to restore this to a different file group (possibly even on a different database)?

I have tried

RESTORE DATABASE my_database
   FILEGROUP = 'newFileGroup'
   FROM DISK='C:restorebackupOfFileGroup.bak' 
   WITH RECOVERY

But get the following error:

Filegroup 'newFileGroup' cannot be restored because it does not exist in the backup set.

Answer :

Is it possible to restore this to a different file group

No.

possibly even on a different database)

No.

Leave a Reply

Your email address will not be published. Required fields are marked *