SQL Repository
  • Home
  • Articles
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Code Snippets
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Interview Questions
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • How To
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Contact





SQL Server Patching

On 09 Oct, 2015
MS SQL DBA
By : Charith Silva
No Comments
Views : 2387

It’s important to install SQL Server service packs whenever they are available and keep database servers up-to-date. Service Packs contain important fixes and they are tested rigorously than incremental releases like cumulative updates, so they’re pretty important to install and make the SQL server bug free. But they may contain some changes to the system that occur unexpected side effects, so you need to test your application with the service pack before you install it in production database server. Service packs correct known problems and provides updates that extend product functionality. SQL Server service packs keep the product current, and extend and update your SQL Server functionality. Thay are cumulative; each new service pack contains all the fixes in previous service packs, as well as any new fixes.

 

Available SQL Server service packs and direct download links.

SQL Server Service Pack Description Download Link
SQL Server 2005 SP1 SQL Server 2005 SP1 upgrade all editions and service levels of SQL Server 2005 to SP1. http://www.microsoft.com/en-us/download/details.aspx?id=22954
SQL Server 2005 SP2 SQL Server 2005 SP2 service pack upgrades all service levels of SQL Server 2005 to SP2. http://www.microsoft.com/en-gb/download/details.aspx?id=9969
SQL Server 2005 SP3 SQL Server 2005 SP3 service pack upgrades all service levels of SQL Server 2005 to SP3. http://www.microsoft.com/en-us/download/details.aspx?id=14752
SQL Server 2005 SP4 SQL Server 2005 SP4 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 3 from cumulative update package 1 to cumulative update package 11. http://www.microsoft.com/en-gb/download/details.aspx?id=7218
SQL Server 2008 SP1 SQL Server 2008 SP1 upgrade all editions and service levels of SQL Server 2008 to SP1. https://www.microsoft.com/en-gb/download/details.aspx?id=20302
SQL Server 2008 SP2 SQL Server 2008 SP2 upgrade all editions and service levels of SQL Server 2008 to SP2. http://www.microsoft.com/en-gb/download/details.aspx?id=12548
SQL Server 2008 SP3 SQL Server 2008 SP3 contains the cumulative updates of SQL Server 2008 SP2 cumulative update package 1 to 4 http://www.microsoft.com/en-us/download/details.aspx?id=27594
SQL Server 2008 SP4 SQL Server 2008 SP4 upgrade all editions and service levels of SQL Server 2008 to SQL Server 2008 SP4. http://www.microsoft.com/en-us/download/details.aspx?id=44278
SQL Server 2008 R2 SP1 SQL Server 2008 R2 SP1 upgrade all editions of SQL Server 2008 R2 to SP1. http://www.microsoft.com/en-gb/download/details.aspx?id=26727
SQL Server 2008 R2 SP2 SQL Server 2008 R2 SP2 contains the hotfixes that were included in Cumulative Update 1 through Cumulative Update 5 for SQL Server 2008 R2 Service Pack 1 (SP1). https://support.microsoft.com/en-us/kb/2630458
SQL Server 2008 R2 SP3 SQL Server 2008 R2 SP3 upgrades all editions and service levels of SQL Server 2008 R2 to SQL Server 2008 R2 SP3. http://www.microsoft.com/en-us/download/details.aspx?id=44271
SQL Server 2012 SP1 SQL Server 2012 SP1 upgrade all editions and service levels of SQL Server 2012 to SP1. https://www.microsoft.com/en-gb/download/details.aspx?id=35575
SQL Server 2012 SP2 SQL Server 2012 SP2 upgrade all editions and service levels of SQL Server 2012 to SP2. https://www.microsoft.com/en-gb/download/details.aspx?id=43340
SQL Server 2014 SP1 SQL Server 2014 SP1 upgrades all editions and service levels of SQL Server 2014 to SQL Server 2014 SP1. http://www.microsoft.com/en-us/download/details.aspx?id=46694

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Google+ (Opens in new window)

Related



Previous Post Next Post 

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.


Number of Posts : 87
All Posts by : Charith Silva

Leave a Comment

Click here to cancel reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">





  • Popular
  • Recent
  • Database stuck in “Restoring” state

    19579 views
  • Find the modified date of SQL Server Agents Jobs

    10623 views
  • Script to Check TempDB Speed

    5652 views
  • PING all the Linked Servers and get a status report

    5317 views
  • Log shipping Alerts failing to send emails

    5046 views
  • Moving the tempdb database

    27 Jan, 2016
  • Script to Check TempDB Speed

    14 Jan, 2016
  • SQL Server buffer pool

    05 Nov, 2015
  • Log shipping Alerts failing to send emails

    04 Nov, 2015
  • View queries waiting for memory grant

    21 Oct, 2015

Useful links

  • Books Online for SQL Server 2012
  • Developer Reference for SQL Server 2014
  • Download SQL Server
  • Installation for SQL Server 2012
  • Microsoft Virtual Academy
  • SQL Server Online Training
  • Transact-SQL Reference
  • Tutorials for SQL Server 2012

Tags

.CSV 70-461 AdventureWorks 2012 ALL ANY CAST Chinook Database Code Snippet CONVERT CTE dataset datasource Dates DATETIME divide by zero Duplicates Exam EXCEPT expressions FORMAT IF Import Indexes INTERSECT Jobs NULLIF REBUILD Recursive CTE REORGANIZE ROW_NUMBER() Schedules Sequence SOME sp_stop_job SQL Server 2012 SQL Server Agent SSIS SSRS T-SQL Tally Table T_SQL UAC Permissions Error UNION UNION ALL

Recent Comments

  • Rudnei Silva on Log shipping Alerts failing to send emails
  • johnson Welch on Database stuck in “Restoring” state
  • Neil on Database stuck in “Restoring” state
  • Mark Gribler on MS SQL Database Administrator Interview Questions – Part 4

Google Analytics Stats

Latest Tweets:

  • 7 years ago Attended @SQLSatMcr yesterday - it was amazing! Roll on @sqlsatcambs! Won some Beats Headphones courtesy of @SQLDBApros - thanks guys! :)
  • 7 years ago Looking forward to attending @SQLSatMcr - its too far off though!!!
  • 7 years ago Simple Post: WhoIsActive SPROC: http://t.co/LZvQUaeapK
  • 7 years ago POST: Index REBUILD or Index REORGANIZE: http://t.co/h3L0N37vw4
  • 7 years ago How to Ping all Linked Servers: http://t.co/Q2QxusrKjO
  • 7 years ago For beginners - T-SQL Divide by Zero Error: http://t.co/BBhgoH5hK9

© Copyright 2015 SQL Repository. All Rights Reserved by SQL Repository