Home Forums SQL Server 7,2000 Backups Restore DB backup from Enterprise Edition to Standard Edition RE: Restore DB backup from Enterprise Edition to Standard Edition

  • November 28, 2012 at 10:59 am

    #1563340

    chetanr.jain (1/10/2011)

    Team,

    i have my production database on SQL 2000 Enterprise Edition.

    Now to test one of the component, i need to restore the backup to another server. To save on the cost, we have been given SQL 2000 Standard Edition ( not the enterprise Edition).

    Can i restore the prod db backup (SQL 2000 Ent) to Dev Box ( SQL 2000 Std).

    If you are only doing testing/development, you would be better of with Developer Edition, since it has all of the features of Enterprise Edition, and costs less than Standard Edition.