2

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.
  • I believe that you have to restore the PRIMARY filegroup first. My understanding is that the information on the filegroups in the database is maintained in the primary filegroup. – RLF Oct 16 '14 at 13:17
3

Is it possible to restore this to a different file group

No.

possibly even on a different database)

No.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.