Home > SQL Server Updates > How to install latest build of the SQL Server

How to install latest build of the SQL Server

November 9th, 2007 Leave a comment Go to comments

In used to be a very simple answer to the question, install Microsoft SQL Server RTM version (internal Microsoft name for the release version of the product – Release To Manufacturing), and on top of it install latest server pack. It’s not that simple any more if you would like to use the latest version on the product.

Current Microsoft policy for the SQL Server updates described at this KB article: http://support.microsoft.com/kb/935897 and is called an ISM (Incremental Servicing Model). In short there are GDR/CU (general distribution release/cumulative update) and OD/COD (on-demand/critical on-demand) incremental updates. GDR include service packs. GDR (2000 and 2005) and CU (2000 only) are normally available for free via Microsoft download center while CU, OD and COD (2005) have to be requested via support web site (it’s free and do not require support contract with Microsoft) and OD and COD (2000) are available from here and do require support contract with Microsoft.

In short:

SQL Server 2005:

SQL Server 2000:

With no SQL Server 2000 SP5 and SQL Server 2005 SP3 dates available yet, ISM is the only option to stay on top of SQL Server updates. Ones again a word of advise: test, test, test every update on you QA/Test server, before deploying in production.

I track latest CU builds form both SQL Server 2000 and 2005 with links to KB support articles, so come back often to stay on top of changes.

Categories: SQL Server Updates Tags:
  1. No comments yet.
  1. No trackbacks yet.