How to Obtain and Install SQL Server Service Packs

How to Obtain and Install SQL Server Service Packs

If you are maintaining SQL Server instances,You must be aware of how SQL Server updates and fixes are released, and how you can obtain them.

First, know about SQL-Server Relaease:

RTM:- Release to Manufacturing. It is the original,  build version of the product,.what you get on the DVD or when you download the iso file from MSDN website.

Hotfix:- Designed to fix a single issue, usually after a case has been raised through Microsoft CSS to the SQL Server Product Team.

Cumulative Update :-Cumulative package of hotfixes (usually 20-40) that also includes all previous cumulative updates for that Service Pack. Cumulative Updates are not fully
regression tested. Cumulative Updates are released every eight weeks.

Service Pack :-Much larger collection of hotfixes that have been fully regression tested.
Service Packs are only released every 12-18 months.

To get the updates for Sql-Server link:- Go to here…