This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 2%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Is there an issue if back up of SQL Express DB is restored on MS SQL Server DB?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Shrihari Sondur ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @Shrihari Sondur ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
MS SQL Express is the free Edition of MS SQL Server, the database engine is the same.
Als long as the version matches, you can restore a database taken from Express on any other edition Standard/Developer/Enterprise.
Hi @Shrihari Sondur ,
You can add more information. For example, you want to restore a backup from SQL Server 2019 Express Edition to SQL Server 2019 Standard Edition.
Different Editions of the same version of SQL Server are at the same compatibility level. So, it is possible to restore successfully unless you want to restore the backup from Standard Edition or Enterprise Edition to Express Edition and encounter the database size problem, because Express Edition has some limitations.
Also, backups of lower versions can be restored to higher versions, and backups of higher versions cannot be restored to lower versions.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".