Good evening,
I have an application that is hosted an application on a sql 2008 express.
Now the db has reached 4 Gb an so is no longer usable.
I would like to know if it's possible to update in place the version to at least 2008R2 express edition to increase the database limit to 10 Gb
kind regards
Yes, that is possible, but you need to be on Service Pack 4 to upgrade.
There is little reason to go to SQL 2008 R2, since it is out of support just as much as SQL 2008 is. So SQL 2019 is a better bet, although there is a small risk that your application is using discontinued functionality.
Hi @pozlu0,
Agree with Erland.
And it is recommended to upgrade to a higher version of SQL Server, because SQL Server 2008 R2 is no longer supported since July 9, 2019. The lack of support means your databases might be vulnerable to security attacks that have been addressed by recent upgrades. You can upgrade SQL Server express from 2008 with sp4 to 2017 directly.
If you have any question, please feel free to let us know.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
12 people are following this question.
