Share via

Can we restore Standard database backup to Express edition

Harshad Pednekar 21 Reputation points
2020-10-26T05:41:46.263+00:00

Hi,

If we have database backup from SQL Server 2016 Standard Edition then can we restore that backup to SQL Server 2016 Express Edition?

Regards,

Harshad Pednekar

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,639 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 21,786 Reputation points Microsoft Vendor
    2020-10-26T06:25:43.487+00:00

    Hi @HarshadReddy Pednekar,

    Yes, you can. But you need to consider limitations of Express edition, DB size is one as VaibhavChaudhari mentioned, etc. You need to make sure you are not using any "standard specific" features. You can run following script to check if database using any edition specific features. 

    Use DBname  
Go  
select * from sys.dm_db_persisted_sku_features  
Go

    If above query returns no results that means you are not using any feature standard edition specific.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,721 Reputation points
    2020-10-26T05:53:59.843+00:00

    Yes, but you will have to check the DB size and consider other limitations of Express edition

    See similar thread here - https://dba.stackexchange.com/questions/174207/restore-database-according-to-editions

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    2 people found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.