Step 4: Obtain hotfixes and prepare for deployment

Learn how to obtain the latest hotfixes for your SQL Server products.

Now that you've deployed the service packs, you need to download the latest hotfix for your SQL Server products.

Refer to the database of SQL Server versions Web site to see the latest hotfix that is available for your supported SQL Server product. (Some of the fixes will be marked as PSS-only, which means they are only available to those who have paid for Product Support Services.)

You can also search for hotfixes by visiting the Microsoft Download Center, searching for "hotfix" and selecting "SQL Server" as the product. Once the results are returned, change the sort order to "Date" to see the latest recommended, publicly available hotfix at the top of the list.

(Note: If you have a clustered SQL Server instance or want more information on the SQL Server hotfix process, refer to the information in Knowledge Base article KB330391.)


HOW TO PATCH SQL SERVER, PART 2

 Home: Introduction
 Step 1: Segregate your scan results
 Step 2: Obtain service packs and prepare for deployment
 Step 3: Deploy service packs
 Step 4: Obtain hotfixes and prepare for deployment
 Step 5: Deploy hotfixes
 Step 6: Re-assess network
 Step 7: Plan next assessment
 Back: How to patch SQL Server, part 1

 

ABOUT THE AUTHOR:
Chip Andrews is the director of research and development for Special Ops Security Inc. and the founder of the SQLSecurity.com Web site, which focuses on Microsoft SQL Server security topics and issues. He is also the author of SQL Server Security.

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close