sql-server-2008-r2sql-server-2008r2-expressbackup-strategies

Migration MSSql Db - from SQL Server 2008 R2 Enterprise backup can restore in SQL Server 2008 R2 Express version


I have a quick simple question: can a SQL Server 2008 R2 Enterprise/ Developer edition backup be restored in a SQL Server 2008 R2 Express version?

Also what feature will effect if we migrate from Enterprise or Developer edition to Express version like we used

- FTS(Full-Test search) 
- Reporting services 
- SSRS 
- SSIS 
- SQL job for auto backup etc.

Solution

  • First of all, there is no SQL Server Ultimate edition - we have Express, Web, Standard, Enterprise, Developer and that's about it. Your source server is a Developer edition.

    But yes - as long as the destination's version (2008 R2) is identical (or newer), you can restore a backup from a source server (here also 2008 R2).

    You just can never go back in time - your backup from 2008 R2 cannot be restored on 2008 or 2005 (or even older ones)

    Update:

    See here on MSDN for a detailed matrix of which features are included in which editions