sql express 2019 end of life

Question

Hello, I am looking at what is the end of life for SQL express 2019 is. how do i determine if a pc i use has an extended version?

Answer 1

Hello Daniel Dennison, the end of life for SQL Server 2019, including SQL Express 2019, follows the Fixed Lifecycle Policy. Here are the key dates:

• Mainstream support ends on February 28, 2025
• Extended support ends on January 8, 2030

To determine if a PC you use has an extended version of SQL Express 2019, you can follow these steps:

1. Connect using SSMS:
   1. Open SSMS and connect to your SQL Server instance
   2. The version information will be displayed in parentheses along with the username used to connnect
2. Run a query:
   1. Connect to the SQL Server instance and run the following query

            SELECT @@VERSION
      

   2. This will provide detailed information about the SQL Server version, including whether it is an extended version
3. Use the SERVERPROPERTY function:
   1. Run the following query in SSMS

            SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')
      

   2. This will return the product version, product level, and edition, helping you determine if it is an extended version

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi @Daniel Dennison,

SQL Server 2019 follows the Fixed Lifecycle Policy.

This applies to the following editions: on Linux (all editions), on Windows (all editions)

Listing	Start Date	Mainstream End Date	Extended End Date
SQL Server 2019	Nov 4, 2019	Feb 28, 2025	Jan 8, 2030
SQL Server 2019	Nov 4, 2019	Feb 28, 2025	Jan 8, 2030

Regards，

Zoe Hui

---

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