SQLTeam.com | Weblogs | Forums

Restore database from backup file Enterprise to Standard edition


I have taken Backup in Enterprise edition with FileGroups i need to restore in Standard edition
Otherwise, how to take Enterprise Database backup file with having FileGroups.



I think you would have to:

  1. take the backup
    2, restore the backup in a new database (Ent. edition)
  2. remove EE features
  3. backup result
  4. restore in standard

Haven't tried this though


Filegroups can be used in standard edition. Do you mean something else?