SQL Server 2008 SP2 / SQL Server 2005 SP4 upgrade

Posted on 2011-10-24
Last Modified: 2012-05-12

I need to install 2008 SP2 and 2005 SP4 on the production  servers. I had experienced issues when doing these SP's before due to missing msi and msp files (deleted by windows admins due to low disk space issues) but in non-prod environments. Since I am going to work on prod, I would like to find out if there are any missing msi or msp files before starting the upgrades, is there any way I can find that? Your inputs are truly appreciated.

Question by:rocky_lotus_newbie
    LVL 2

    Expert Comment

    The smart move would be to virtualize your production servers and test the upgrade. This is a procedure that I perform on a regular basis. VMWare ESXi server is a "free" product. You can take some existing machine you have and create the server and then manage it from a workstation. Once virtualized you can check on any number of scenarios before committing changes on your production server. Using ESXi is pretty straight forward and shouldn't take you too long to learn to do the testing. This is really the only way that you are going to know that your upgrades and changes are going to work on your production boxes. The cost is nothing for ESXi, having some extra hardware around shouldn't be too much of a burden if you don't have it now.
    LVL 5

    Expert Comment


    Download the required SP's from the related sites. Install them in dev box. Monitor it for couple of days.

    At the time of installation only you can able to know whether is there any thing missing (msi) files like that, so that you can able to use the same SP for live also.

    LVL 4

    Accepted Solution

    used this link to find the missing msi/ msp files
    LVL 4

    Author Closing Comment

    Using the link below, I was able to find all the missing msi and msp files before starting the install

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now