SQL Server 2008 End Of Support

SQL Server 2008 and SQL Server 2008 R2 will cease to be supported by Microsoft on 7th September 2019. This is an ideal business opportunity to migrate existing database architectures to the more robust SQL Server 2012 platform and above.

It also makes business and legal sense to migrate to a supported Microsoft Platform so that businesses can leverage the increased security and stability of storing customer and business data. This is essential to confirm to new European wide statues regarding GDPR.

Withdrawal Of Support

Microsoft has provided the following schedule to indicate phased withdrawal of support for SQL Server 2008. Refer to this for scheduled migration.

Products Released

Lifecycle Start Date

Mainstream Support End Date

Extended Support End Date

Service Pack Support
  End Date

SQL Server 2008





SQL Server 2008 Service Pack 1


Not Applicable

Not Applicable


SQL Server 2008 Service Pack 2


Not Applicable

Not Applicable


SQL Server 2008 Service Pack 3


Review Note

Review Note


SQL Server 2008 R2





SQL Server 2008 R2 Service Pack 1


Not Applicable

Not Applicable


SQL Server 2008 R2 Service Pack 2


Review Note

Review Note


What Version Of SQL Server Am I Running

There are two very quick ways to identity which version of SQL Server you are running:

Use SQL Health Monitor

SQL Health Monitor provides the full version information on the Sever->System screen as shown below:

(You can always click the CHECK SQL Version button which will interrogate the server for all particulars of its current version)

Showing the SQL Server version

Use SSMS (SQL Server Management Studio)

If you start a new query:

And enter the following into the editor:


This will bring the relevant version information to the Results Grid.

If the version of SQL Server is 2008 or 2008R2 then you will need to migrate.

Orpheus Enterprises can assist in the migration of your legacy database systems. If you require information or support: Contact Orpheus Enterprises

Leave a Reply

Your email address will not be published. Required fields are marked *