Upgrade form a sql express vesion to another

pozlu0 216 Reputation points
2021-04-08T18:02:16.627+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,488 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 100.1K Reputation points MVP
    2021-04-08T21:47:47.713+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-04-09T02:26:29.763+00:00

    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.

    0 comments No comments