Home Forums SQL Server 2008 SQL Server 2008 - General Restoring SQL2008 Enterprise Edition db into SQL2008 Standard edition question RE: Restoring SQL2008 Enterprise Edition db into SQL2008 Standard edition question

  • Actually, even if they back it up with compression, you can restore it. I tested this recently here at my work, as we have clients who (tightwads) use SQL Express.

    BUT one thing to be wary of, is to make sure the Vendor isn't using Enterprise only features in their DB. Things like partitioned tables comes to mind.

    Jason