SQLTeam.com | Weblogs | Forums

Restore database from backup file Enterprise to Standard edition


#1

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.

Regards,
RK


#2

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


#3

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