Sql-server – Restore backup to different filegroup

filegroupsrestoresql serversql-server-2008-r2

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:\restore\backupOfFileGroup.bak' 
   WITH RECOVERY

But get the following error:

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

Is it possible to restore this to a different file group

No.

possibly even on a different database)

No.

The WITH MOVE 'logical_file_name_in_backup' refers to the internal name of that file, not the database name.

Run this to see what I mean. You're looking at the name column

SELECT * FROM sys.database_files

Edit:

Need WITH REPLACE now... see first link above and look for

The database name is different from the database name recorded in the backup set.

After you restore the filegroup, you need to take a tail log backup of the restored database .
Restore the lastest differential you may have to with norecovery.
Restore all the tlog backups to with norecovery.
Restore the tail log backup from step 1 to with recovery.