Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Can I restore a backup from SQL 2008 R2 to SQL 2008 R2 Express?

Answered Can I restore a backup from SQL 2008 R2 to SQL 2008 R2 Express?

  • Thursday, April 26, 2012 9:01 PM
     
     
    Sign In to Vote
    0

    Is it possible to take a DB backup from a full version of SQL 2008 R2 and restore it to a system running SQL 2008 R2 Express?

    Thank you,

    Brad

     

All Replies

  • Thursday, April 26, 2012 9:23 PM
     
     Answered
    Sign In to Vote
    0

    It depends so answer is both Yes and No.

    Yes, if size of the databae is less than 10 GB and you are not using any feature that is only available in either Standard or enterprise edition (for e.g. Transperent Data Encryption, Table Partitioning  etc.)

    No, if database size is more than 10 GB and you are using a feature in the database that is only available in that edition.