• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

SQL Server 2008 SP2 / SQL Server 2005 SP4 upgrade

Hello,

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.


Regards,
Rocky
0
rocky_lotus_newbie
Asked:
rocky_lotus_newbie
  • 2
1 Solution
 
LuckyDuckCommented:
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.
0
 
VENKAT KOKULLASQL Server DBACommented:
http://www.microsoft.com/download/en/details.aspx?id=184

http://www.microsoft.com/download/en/details.aspx?id=184

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.


--Venkat
0
 
rocky_lotus_newbieAuthor Commented:
used this link to find the missing msi/ msp files

http://support.microsoft.com/kb/969052
0
 
rocky_lotus_newbieAuthor Commented:
Using the link below, I was able to find all the missing msi and msp files before starting the install

http://support.microsoft.com/kb/969052
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now