question

pozlu0 avatar image
0 Votes"
pozlu0 asked AmeliaGu-msft answered

Upgrade form a sql express vesion to another

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @pozlu0,
Agree with Erland.

85994-01.jpg
86032-02.jpg

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.



01.jpg (223.4 KiB)
02.jpg (78.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.